plpgsql
PLPGSQL how to use an array in a execute statement?
I have a plpgsql function that executes a query, but when i put an array into it it wont parse it, at least it gives me this error:[详细]
2023-02-01 13:48 分类:问答Return multiple fields as a record in PostgreSQL with PL/pgSQL
I am writing a SP, using PL/pgSQL. I want to return a record, comprised of fields from several different tables. Could look something like this:[详细]
2023-02-01 05:55 分类:问答PostgreSQL stored procedure using iBatis
The error occurred while applying a parameter map: --- Check the newSubs-InlineParameterMap. --- Check the statement (query failed).[详细]
2023-01-31 23:02 分类:问答Storing Open Hours/Holidays
What kind of SQL schema would you suggest for storing hours and holidays, and what kind of query to check if a restaurant is open? Right now I have this:[详细]
2023-01-31 08:22 分类:问答PLPGSQL returned array, how to parse in Python?
I\'m getting an array from plpgsql that looks like this: [0:2]={ "(ab023500-ceef-41d6-af33-635964dbffde,Koen,\\"\\",Schmeets,{koen@heizoo.com},31631205427},\\"{\\"\\"Test[详细]
2023-01-30 14:09 分类:问答ERROR: must be owner of language plpgsql
I\'m using PostgreSQL v9.0.1 with Rails (and it\'s deps) @ v2.3.8, owing to the use of the fulltext capability of postgres, I have a table which is defined as:[详细]
2023-01-29 07:02 分类:问答Delete row in trigger (PostgreSQL)
I\'ve got a trigger on update, that should delete the row OLD*, but I don\'t know the table structure.[详细]
2023-01-28 10:26 分类:问答Variable substitution in PL/pgSQL
I have a select statement that is generated dynamically based on the supplied parameter. The problem is that postgresql always says:[详细]
2023-01-28 02:11 分类:问答pl/pgsql array as input to an aggregate function
i am writing pl/pgsql function that does some statistics processing. using 8.2 of postgres. i want to use this handy aggregate function:开发者_如何学编程[详细]
2023-01-21 11:42 分类:问答How to use declared parameters as component of a query in Pl/pgSQL?
I am tryingto do a generic function in pl/pgsql. I am facing a problem that I can\'t figure out. See in the declare block I assigned value to some parameters. I would like to know how to use them as c[详细]
2023-01-21 11:33 分类:问答