Question : I have a function that declares: DECLARE r RECORD; The data on this record varies and at some […]
Tag: plpgsql
PostgreSQL trigger to update date modified [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
PostgreSQL function call error: structure of query does not match function result type
Question : i have function CREATE FUNCTION create_post( txt text, created BIGINT, photourl text, user_id bigint ) RETURNS TABLE( id […]
if multiple users run a query that creates a temp table at the same time, would the data in the table be corrupted in each session? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
How to put the results of a query into a variable?
Question : I have written a Postgres anonymous block. In which I have written join query on multiple tables like: […]
Why does ‘plpgsql’ not appear in the pg_extension table?
Question : I have two Postgres 9.1 installations. One works properly, the other does not. On the working installation: dc=# […]
How to put the results of a query into a variable?
Question : I have written a Postgres anonymous block. In which I have written join query on multiple tables like: […]
How to get query runtime in PL/pgSQL to be as fast as console query runtime?
Question : Basically I want to assign the result of a query to a custom type attribute. However I noticed […]
How to create tablespace if it does not exist
Question : When I create a new schema in Postgres through executing a script in psql I want to put […]
How to use variables in procedure (not function)? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]