plpgsql

相关标签：javascript jquery android 多少钱 iPhone

PostgreSQL stored procedure data parameter

I have开发者_开发问答 the following stored procedure, which returns 0 results but if the run the query by itself it result lot of results. What am i missing.[详细]

2023-03-06 00:22 分类：问答
PL/PgSQL confusing error

I have written the following function for Postgres and it works fine on my local windows machine when installed via pgAdmin. When I try to add it to my linux based sever install it throws compile erro[详细]

2023-03-05 14:50 分类：问答
how to replace multiple words at once in postgresql

to replace multiple words, i\'m using looping thru all candidates, and replacing one by one. is there a better way?[详细]

2023-03-05 01:45 分类：问答
PostgreSQL dynamic table access

I have a products schema and some tables there. Each table in products schema has an id, and by this id I can get this table name, e.g.[详细]

2023-02-28 23:16 分类：问答
Save SQL query to variable

I have written a PL/PgSQL trigger and i need to save the query (in fact the result set) to variable. See below:[详细]

2023-02-26 15:56 分类：问答
Change case, or use callback function, in regexp_replace in PostgreSQL?

Is it possible to change the case of what you matched in REGEXP_REPLACE to upper or lower case, in Postgres 8+? In Perl you can use \'\\u\', \'\\U\', \'\\l\', and \'\\L\', but there doesn\'t seem to b[详细]

2023-02-25 00:50 分类：问答
Access to a row, which started a trigger

I know there\'re ways to access to query type, table names, oids etc. in trigger definitions: http://www.postgresql.org/docs/8.3/static/plpgsql-trigger.html[详细]

2023-02-23 06:04 分类：问答
PostgreSQL - how to execute "free-standing" code?

I am used to the Query Editor in SQL Server where one can freely write & execute T-SQL. How do I get the following code to execute in PostgreSQL without having to create a function out of it?[详细]

2023-02-22 01:30 分类：问答
Commit, savepoint, rollback to in PostgreSQL?

Can someone please explain to me why does COMMIT in this function returns EXCEPTION ? DECLARE XNar CURSOR (forDATE Varchar) IS[详细]

2023-02-19 20:54 分类：问答
Problem with a PostgreSQL function that return multiple rows

Hello i want to return a multiple row from a function but i have this persistant error anybody can give me a hand, thanks!![详细]

2023-02-19 14:55 分类：问答