plpgsql

153 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Why are TRIM and SUBSTRING not working in this PL/pgSQL function?
user_44752900
•
1
1
29
plpgsql postgresql
Postgres SELECT that doesn't work with the first function call
user_134705940
•
1
1
40
plpgsql postgresql function
How determine if range list contains specified integer
user_7424020
•
1
2
67
plpgsql join postgresql arrays sql
How do I return a table from a function with a bespoke column name?
user_11639600
•
1
1
34
dynamic-sql plpgsql postgresql sql
How to perform a GRANT in a stored procedure using a variable?
user_4767160
•
1
1
115
postgresql-12 plpgsql triggers postgresql
Update statement on PostgreSQL not using primary key index to update
user_63910010
•
2
1
66
amazon-rds plpgsql postgresql
Getting the query plan for statements inside a stored procedure in PostgreSQL
user_63910010
•
4
2
568
amazon-rds plpgsql postgresql
why does postgres set_config's is_local = true not persist the variable for the whole transaction?
user_25145350
•
2
1
504
plpgsql session postgresql transactions variables
How do I copy a bytea column to a server file without PGCOPY or other header in plpgsql
user_31721540
•
2
0
205
export-to-image plpgsql copy postgresql
PSQL passing external variables
user_129746430
•
1
1
370
psql plpgsql parameter-passing postgresql
Hot Questions