Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

PostgreSQL: Same request is slower with plpgsql language compared to sql

Returning boolean from SQL function

PostgreSQL plpgsql get current procedures oid

postgresql plpgsql

Postgres function: return multiple tables

Is there a way to catch exception of a deferred constraint in pgsql?

How to return a table's rowtype plus an additional column from a function?

How to disambiguate a plpgsql variable name in a ON CONFLICT clause?

PostgreSQL trigger not returning anything

postgresql triggers plpgsql

How to write combinatorics function in postgres?

How to programmatically check if row is deletable?

Recursive function in postgres

SELECT usage with the new CREATE PROCEDURE method

postgresql plpgsql

Perform action before exception call in Postgres trigger function

Returning set of rows from plpgsql function.

sql postgresql plpgsql

Trigger with dynamic field name

unaccent() does not work with Greek letters in plpgsql dynamic query

What does %% in PL/pgSQL mean?

sql postgresql plpgsql

PostgreSQL 9.3: isnumeric() in a condition

How to pass custom type array to Postgres function

Running a SELECT in a PL/pgSQL block

postgresql plpgsql