Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

BREAK statement in PL/pgSQL

postgresql loops plpgsql break

How to perform a select query in a DO block?

It could refer to either a PL/pgSQL variable or a table column

postgresql plpgsql pgadmin

Check if sequence exists in Postgres (plpgsql)

Postgres trigger after insert accessing NEW

Optional argument in PL/pgSQL function

Is SELECT or INSERT in a function prone to race conditions?

SELECT .. INTO to create a table in PL/pgSQL

INSERT with dynamic table name in trigger function

Return zero if no record is found

Function with SQL query has no destination for result data

sql postgresql plpgsql

How to create sequence if not exists

PostgreSQL cannot begin/end transactions in PL/pgSQL

Refactor a PL/pgSQL function to return the output of various SELECT queries

PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement

Return setof record (virtual table) from function

Can I make a plpgsql function return an integer without using a variable?

ERROR: unterminated quoted string at or near

PostgreSQL Exception Handling

postgresql plpgsql

Postgres SELECT ... FOR UPDATE in functions