Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

Use text output from a function as new query

Postgres 9.4: fast way to convert color from hex to rgb representation

sql postgresql plpgsql

Longest matching substring

postgresql plpgsql

Reset all columns of a row type to NULL

Check current logging level in plpgsql

postgresql plpgsql

postgres: How to generically make a column immutable?

Using variables in a PL/pgSQL function

concatenate additional text to string variable in pl/pgsql

Commit the transaction after exception is raised

postgresql plpgsql

Default values in Postgres view with triggered instead-of update

postgresql triggers plpgsql

How to pass parameters to a query written in PL/pgSQL?

How to return a newly created ids array from a Postgres function?

arrays postgresql plpgsql

Check if the row is the last one when looping through result set in PL/pgSQL

postgresql plpgsql

Insert a string into a bytea column

prepared statement - using parameter to specify table name

PostgreSQL function returning an arbitrary type

sql postgresql plpgsql plv8

Setting a PostgreSQL variable from inside a CASE statement

postgresql plpgsql

Referring to session variables (\set var='value') from PL/PGSQL

postgresql scope plpgsql psql

Error in dynamic statement PL/PGSQL (functions and operators can take at most one set argument)

postgresql plpgsql

Macros / Meta-programming in Postgres queries