plpgsql
Postgresql: Problem with selecting arrays in set-returning plpgsql function
I am trying to select arrays in a set-returning function in postgres 8.4, but receiving the error: \"array value must start with \"{\" or dimension information\".[详细]
2023-03-24 13:06 分类:问答the cursor for loop in postgresql
We have a function written in pl/sql(oracle) as below: CREATE OR REPLACE PROCEDURE folder_cycle_check (folder_key IN NUMBER, new_parent_folder_key IN NUMBER) IS[详细]
2023-03-17 16:36 分类:问答PostgreSQL Hierarchical Relationship Functions
CREATE TABLE sectors ( sector_id integer PRIMARY KEY, sector_name varchar(100) NOT NULL, parent_sector_id integer REFERENCES sectors(sector_id)[详细]
2023-03-15 06:47 分类:问答Is it possible to append a WHERE clause in SELECT in plpgsql?
开发者_JAVA百科I have a function with several IN params. I need to build a complex select and use the params in the WHERE CLAUSE.[详细]
2023-03-14 17:57 分类:问答automate schema creation in PostgreSQL (maybe plpgsql?)
I have a big database (in PostgreSQL 8.4) which I try to analyse in smaller parts. To do that, I copy parts of the content of the big database to other schemas (I know it is somehow against the philos[详细]
2023-03-13 16:07 分类:问答Cannot run 'select into' from dynamic-named temporary table within plpgsql function
I am dynamcially naming temporary table, inserting some data to this dynamic-named temporary table. But I am not able to get back the data from dynamic-named temporary table to function variable to do[详细]
2023-03-13 04:06 分类:问答plpgsql: concatenation of variable into FROM clause
I\'m new to Postgresql and struggling to build a function for looping over a series of CSV files and loading them. I can make the COPY work just fine with a single file, but I\'m unable to get the FOR[详细]
2023-03-10 16:04 分类:问答Unexpected SQL results: string vs. direct SQL
Working SQL The following code works as expected, returning two columns of data (a row number and a valid value):[详细]
2023-03-09 05:01 分类:问答while function in postgresql
I want to insert records to a table by function. CREATE OR REPLAC开发者_开发问答E FUNCTION insert_wilda()[详细]
2023-03-07 13:35 分类:问答In a PostgreSQL WHERE clause, how do I find all rows whose ID's are NOT in an array?
Okay, I\'ve got a stored procedure... how do I find all rows whose ID\'s are not in an array? (Keep in mind that I\'m using a PostgreSQL array that is created dynamically when the stored procedure is[详细]
2023-03-06 18:04 分类:问答