Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

Invalid input syntax for type integer: "(2,2)" with composite data type while executing function

How to migrate oracle's pipelined function into PostgreSQL

postgresql plpgsql

JPA & PostgreSQL: How do I call a stored procedure with void return type?

java postgresql jpa plpgsql

Convert string to column name

How to call a stored procedure in another procedure and use the result of it in the same procedure of Postgresql?

postgresql plpgsql

PostgreSQL update trigger Comparing Hstore values

Looping through a CURSOR in PL/PGSQL without locking the table

FOR loop over a date range in Postgres

postgresql plpgsql

Should i use STABLE or VOLATILE in a function that performs a query?

PSQL Command Line Arguments in DO script

building a trigger function to process json data with postgres

converting SETOF into a string

postgresql 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