PL/pgSQL is the default procedural language for PostgreSQL.
I've got this PL/pgSQL function which must return some users information. CREATE OR REPLACE FUNCTION my_function( user_id …
postgresql function stored-procedures plpgsql psqlGiven a table name, how do I extract a list of primary key columns and their datatypes from a plpgsql …
sql postgresql plpgsqlI am trying to loop through an integer array (integer[]) in a plpgsql function. Something like this: declare a integer[] = …
arrays postgresql loops plpgsql postgresql-8.4I'm trying to use cursors for a query that joins multiple tables. I've seen that for oracle there is a …
postgresql loops cursor plpgsqlWe are redesigning table schema in postgres. It used to have a linker table to the two tables partner and …
postgresql data-migration plpgsqlIs there anything like table variables in T-SQL? In Sql Server it looks like this: DECLARE @ProductTotals TABLE ( ProductID int, …
sql postgresql plpgsql table-variableI have two questions about using SELECT … FOR UPDATE row-level locking in a Postgres function: Does it matter which columns …
postgresql plpgsql postgresql-9.1 select-for-updateAs far as I can tell, my function properly resembles the samples I've seen. Can someone clue me in as …
postgresql parameter-passing plpgsql set-returning-functionsI am using Postgres for a django project and I am currently implementing a database backup/restore system that as …
postgresql plpgsql database-restoreThis probably sounds like a really stupid question, but how do I declare a variable for used in a PostgreSQL 9.3 …
postgresql variables set plpgsql declare