Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

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

Hashing a String to a Numeric Value in PostgreSQL

PostgreSQL: ERROR: 42601: a column definition list is required for functions returning "record"

The forgotten assignment operator "=" and the commonplace ":="

SQL Sub queries in check constraint

PostgreSQL - Iterate over results of query

sql postgresql plpgsql

Postgresql, update if row with some unique value exists, else insert

postgresql triggers plpgsql

DROP FUNCTION without knowing the number/type of parameters?

Iterating over integer[] in PL/pgSQL

How to write function for optional parameters in postgresql?

sql postgresql plpgsql

How can I execute pl/pgsql code without creating a function?

postgresql plpgsql