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
Using %rowtype when returning in a PostgreSQL function
Nov 10, 2022
database
postgresql
plpgsql
Postgres Function to insert multiple records in two tables
Aug 20, 2022
sql
database
postgresql
plpgsql
postgresql-9.4
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
« Newer Entries
Older Entries »