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
How to pass custom type array to Postgres function
Oct 29, 2022
php
sql
postgresql
postgresql-9.1
plpgsql
Running a SELECT in a PL/pgSQL block
Aug 28, 2022
postgresql
plpgsql
How to loop through split string
Mar 01, 2022
sql
postgresql
plpgsql
How to insert multiple rows using a function in PostgreSQL
Sep 25, 2022
function
postgresql
plpgsql
sql-insert
postgresql-9.3
PL/pgSQL column name the same as variable
Oct 15, 2022
postgresql
plpgsql
race-condition
uniqueidentifier
Column definitions in ROWS FROM() with multiple unnest calls
Oct 20, 2022
sql
arrays
postgresql
plpgsql
unnest
PostgreSQL function with a loop
Sep 25, 2022
function
postgresql
aggregate-functions
plpgsql
How to remove duplicate rows with foreign keys dependencies?
Feb 18, 2022
database
postgresql
exception
foreign-keys
plpgsql
pg_stat_activity doesn't update within a procedure or transaction
Oct 24, 2021
postgresql
plpgsql
Cast produces 'Returned type character varying does not match expected type character varying(8)'
Dec 13, 2019
postgresql
types
plpgsql
varchar
postgresql-9.1
Update multiple columns in a trigger function in plpgsql
Oct 17, 2022
sql
postgresql
triggers
plpgsql
dynamic-sql
Split string with two delimiters and convert type
Sep 05, 2022
postgresql
plpgsql
set-returning-functions
Can Postgres stored functions have both a return value AND out parameters?
Nov 14, 2022
postgresql
stored-procedures
plpgsql
Dynamically-generated table-name in PostgreSQL COPY command
Sep 25, 2022
postgresql
plpgsql
Shredding XML in postgresql
Jun 21, 2022
xml
postgresql
plpgsql
PL/pgSQL anonymous code block
Aug 26, 2022
postgresql
plpgsql
Loop through columns of RECORD
Feb 21, 2021
postgresql
loops
for-loop
record
plpgsql
Array of arrays in PostgreSQL
Nov 10, 2022
sql
postgresql
plpgsql
PL/Proxy returning Unsupported Type on Stored Procedure Call
Jul 10, 2021
postgresql
plpgsql
Reference psql parameter inside PL/pgSQL anonymous block
Oct 25, 2022
postgresql
plpgsql
psql
« Newer Entries
Older Entries »