Search code examples
In PostgreSQL, how can you declare a variadic function that accepts arguments of differing types?...


postgresqlplpgsql

Read More
Creating a partial index based on declared variables inside a DO block...


postgresqlplpgsql

Read More
How to execute Anonymous Block PL/pgSQL (PostgreSQL 13) from Npgsql 4.1.5.0 in C#...


c#plpgsqlnpgsqlpostgresql-13

Read More
get velue from query PERFORM 1 into temp FROM master_balance where externalkey = 'jknfl12j3'...


postgresqlplpgsql

Read More
plpgsql: calling a function with 2 OUT parameters...


postgresqlplpgsql

Read More
How to call a function in regexp_replace with matches?...


sqlregexpostgresqlparsingplpgsql

Read More
Convert SQLserver function to postgres...


sql-serverpostgresqlplpgsql

Read More
Why does function i PostgreSQL not raise exception?...


postgresqlfunctionplpgsql

Read More
Convert Hexadecimals to timestamp in postgres...


postgresqlplpgsql

Read More
Query plan caching with pl/pgsql...


postgresqlcachingdatabase-designplpgsqlquery-planner

Read More
Migrate SQL Server functions to PostgreSQL...


sql-serverpostgresqlplpgsql

Read More
FOR EACH STATEMENT and FOR EACH ROW triggers order of execution...


postgresqltriggersplpgsql

Read More
Amazon Redshift CREATE FUNCTION ERROR: 42601: syntax error at or near "default"...


amazon-redshiftplpgsqlstored-functions

Read More
Replace function used in index...


functionpostgresqlindexingplpgsql

Read More
Using like or ilike to create SQL/ PLpgSQL function...


sqlstringpostgresqlplpgsqlsql-like

Read More
Declare a Table as a variable in a stored procedure?...


postgresqlplpgsql

Read More
PostgreSQL extract Year fromDate variable...


postgresqlstored-proceduresplpgsql

Read More
What is the data type of column_name in information_schema.columns?...


postgresqlplpgsql

Read More
Unnesting an array of arrays, to a simple array in plpgsql...


postgresqlplpgsql

Read More
Trigger using adjusted OLD / NEW values...


postgresqltriggersplpgsql

Read More
PostgreSQL Stored Procedure error in declare bloc...


postgresqlstored-proceduresplpgsql

Read More
Splitting comma separated string in PL/pgSQL function...


sqlpostgresqlplpgsql

Read More
how to pass schema_name_variable in stored procedure syntax "call <<schema_name_variable&...


stored-proceduresamazon-redshiftplpgsql

Read More
After insert trigger not giving desired result...


postgresqltriggersplpgsqlpostgresql-10

Read More
PLPGSQL Function: Use Input Parameter in ORDER BY...


postgresqlplpgsql

Read More
how do I pass a user defined type variable to a function as a parameter?...


postgresqlplpgsql

Read More
Declaring Variable based on Select inside a function in Postgres 9...


postgresqlplpgsql

Read More
Postgres 9.6 How to loop over array and insert each array value into tables?...


postgresqlfor-loopplpgsql

Read More
Creating user with password from variables in anonymous block...


sqlpostgresqlplpgsqldynamic-sql

Read More
PLPGSQL parse json IN parameter and compose json OUT parameter...


jsonpostgresqlplpgsql

Read More
BackNext