Search code examples
Dynamic SQL (EXECUTE) as condition for IF statement...

postgresqldynamic-sqlplpgsql

Read More
Dynamically generate columns for crosstab in PostgreSQL...

postgresqlpivot-tableplpgsqldynamic-sqlpostgresql-9.1

Read More
Access and return result from INSERT INTO in PL/pgSQL function...

postgresqlplpgsqlset-returning-functionssql-returning

Read More
Incrementing a number in a loop in plpgsql...

sqlpostgresqlincrementplpgsqlpostgresql-8.4

Read More
How to find the first and last occurrences of a specific character inside a string in PostgreSQL...

postgresqlplpgsql

Read More
Find the statement currently running in my PL/pgSQL code block...

postgresqlmonitoringplpgsql

Read More
Can 2 postgresql functions be called in parallel?...

postgresqlplpgsql

Read More
dblink can't update a table on the same database in an after UPDATE trigger...

triggersplpgsqldblinkpostgresql-9.0slony

Read More
Perform action before exception call in Postgres trigger function...

postgresqlexceptiontriggersplpgsql

Read More
PostgreSQL : when using RAISE NOTICE in psql, can I avoid the "NOTICE :" prefix from the o...

postgresqlplpgsqlpsql

Read More
Loop in function does not work as expected...

sqlpostgresqlloopsplpgsqlcommon-table-expression

Read More
Update record of a cursor where the table name is a parameter...

postgresqlsql-updateplpgsqldynamic-sqldatabase-cursor

Read More
How to declare variables and use them to UPDATE each row based on the preceding row(s)...

sqlpostgresqlplpgsqlwindow-functionsdynamic-sql

Read More
How do I drop all invalid indexes in postgres?...

postgresqlindexingplpgsqlreindex

Read More
How to allow mixed integer and numeric parameters in icase...

sqlpostgresqlplpgsql

Read More
Cast value to type (TEXT) using string representation of type ("TEXT")...

sqlpostgresqlpolymorphismplpgsqldynamic-sql

Read More
Find SUM and MAX in custom aggregate function...

sqlpostgresqlplpgsql

Read More
postgres event trigger and function not working...

postgresqlfunctioneventstriggersplpgsql

Read More
concatenate additional text to string variable in pl/pgsql...

postgresqlconcatenationplpgsqldynamic-sql

Read More
How to commit when inserting records by calling Postgres function...

pythonpostgresqlsqlalchemyplpgsql

Read More
PostgreSQL function has syntax error at IF. Why?...

sqlpostgresqlplpgsqlrdbmssql-function

Read More
Unable to use IF statement in plpgsql...

postgresqlif-statementplpgsql

Read More
How to substitute variable in postgres?...

sqlpostgresqlplpgsql

Read More
How to trim double quotes from string variable in postgreSQL function...

sqlpostgresqlplpgsql

Read More
sql for each district increment column facility...

postgresqlplpgsql

Read More
posgresql 10 How to assigned filtered sum result to different variables?...

postgresqlplpgsql

Read More
Postgresql procedure skip code above Exception?...

postgresqlplpgsqlprocedure

Read More
Retaining and inserting state into a postgres aggregation function...

postgresqlplpgsqltimescaledbpostgresql-triggers

Read More
How to get results from a Postgresql function using EF Core?...

c#postgresqlasp.net-core.net-coreplpgsql

Read More
Function to return dynamic set of columns for given table...

postgresqlfunctionplpgsqldynamic-sql

Read More
BackNext