Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in plpgsql
Getting transactionid(xid) from SQL
Jul 13, 2022
postgresql
transactions
plpgsql
identifier
Postgresql batch insert or ignore
Jul 25, 2019
sql
postgresql
plpgsql
postgresql-9.1
duplicate-removal
Can a function detect the trigger event type?
Oct 26, 2022
postgresql
triggers
plpgsql
Array of composite type as stored procedure input
Nov 18, 2022
arrays
postgresql
stored-procedures
plpgsql
unnest
Add element to empty array
Nov 22, 2021
postgresql
plpgsql
Can I use EXCEPTIONs in a FOR LOOP to force continuation on error?
Mar 27, 2020
postgresql
loops
exception-handling
plpgsql
How to use `RETURN NEXT`in PL/pgSQL correctly?
Oct 14, 2022
postgresql
plpgsql
How to get execution time in postgres
Apr 22, 2022
postgresql
plpgsql
Correctly inserting literals in PL/PgSQL EXECUTE dynamic queries
Oct 21, 2022
sql
postgresql
plpgsql
dynamic-sql
How to remove conditions from WHERE clause if parameters are NULL
Oct 15, 2022
sql
postgresql
null
plpgsql
postgresql function: Final statement returns bigint instead of integer
Jun 04, 2018
sql
postgresql
plpgsql
Psycopg2 callproc and sql parameters
Oct 29, 2022
python
psycopg2
plpgsql
Unescape a string with escaped newlines and carriage returns
Nov 03, 2022
sql
database
postgresql
special-characters
plpgsql
PostgreSQL function with duplicate parameters
Jun 26, 2019
sql
postgresql
stored-procedures
plpgsql
function-parameter
Possible to use a PostgreSQL TYPE to define a dblink table?
Aug 22, 2022
postgresql
plpgsql
postgresql-9.3
use \set variable inside plpgsql declare block [duplicate]
Sep 03, 2022
postgresql
plpgsql
psql
Pass table to postgreSQL function, execute select statement, return table
Oct 26, 2022
postgresql
function
plpgsql
procedural-programming
Is it possible to create a table with a variable name in PostgreSQL?
Jun 20, 2022
sql
postgresql
plpgsql
PostgreSQL CREATE TEMPORARY TABLE inside a plpgsql function
Jun 10, 2022
postgresql
plpgsql
temp-tables
Return multiple rows from plpgsql function
Mar 24, 2019
function
postgresql
plpgsql
« Newer Entries
Older Entries »