plpgsql
Dynamic SQL PostgreSQL
I want to know the basics of dynamic sql especially in PostgreSQL. I was googling for a while but have no luck for getting a good described examples. Maybe someone here could give me some links to the[详细]
2023-04-03 12:52 分类:问答PostgreSQL EXECUTE command success but no change in table
I have the following PostgreSQL script: CREATE OR REPLACE FUNCTION merge_fields() RETURNS VOID AS $$ DECLARE[详细]
2023-04-02 09:20 分类:问答Why I'm getting an error informing that "a result was not expected" when executing stored procedures on PostgreSQL from Java in a batch?
I have this procedure in the database: CREATE OR REPLACE FUNCTION replacePageRelevance(id INT, value REAL) RETURNS VOID AS $$[详细]
2023-04-01 05:53 分类:问答In Java, calling a PostgreSQL function, why I'm getting an error informing that the function doesn't exists?
I have this procedure in the database: CREATE OR REPLACE FUNCTION replacePageRelevance(id INT, value REAL) RETURNS VOID AS $$[详细]
2023-04-01 03:14 分类:问答How to combine particular rows in a pl/pgsql function that returns set of a view row type?
I have a view, and I have a function that returns records from this view. Here is the view definition:[详细]
2023-03-31 12:37 分类:问答Problem using any operator in plpgsql function
When i run this function: CREATE OR REPLACE FUNCTION insert_styles(raw_styles text) RETURNS integer AS $BODY$[详细]
2023-03-30 06:03 分类:问答PL/pgSQL: finding all groups person belongs to (also indirectly)
Simple intro: I have a database with users and groups. Every user might be a member of one or more groups.[详细]
2023-03-29 12:25 分类:问答Assigning variables to output parameters in a PostgreSQL trigger
I\'m starting a PostgreSQL project, after many years with Sybase and SQL Server, and am new to it\'s quirks, but so far have been impressed.[详细]
2023-03-29 05:13 分类:问答Return both OUT parameters and a rowset
I would like to return both output parametrs and a rowset. In DB2, I can accomplish this with the following, and opening a cursor before the stored procedure ended:[详细]
2023-03-29 00:42 分类:问答Set of values in pl/pgsql
I\'m writing some pl/pgsql code in postgres - and have come up to this issue.Simplified, my code looks like this:[详细]
2023-03-28 22:58 分类:问答