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
PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
Sep 23, 2022
postgresql
function
stored-procedures
plpgsql
psql
Return setof record (virtual table) from function
Jan 10, 2017
sql
postgresql
stored-procedures
plpgsql
Can I make a plpgsql function return an integer without using a variable?
Aug 30, 2022
postgresql
function
variables
parameters
plpgsql
ERROR: unterminated quoted string at or near
May 21, 2022
postgresql
ant
triggers
plpgsql
PostgreSQL Exception Handling
Aug 29, 2022
postgresql
plpgsql
Postgres SELECT ... FOR UPDATE in functions
Aug 28, 2022
postgresql
plpgsql
postgresql-9.1
select-for-update
Hashing a String to a Numeric Value in PostgreSQL
Aug 28, 2022
postgresql
plpgsql
postgresql-8.4
PostgreSQL: ERROR: 42601: a column definition list is required for functions returning "record"
Aug 07, 2021
postgresql
parameter-passing
plpgsql
set-returning-functions
The forgotten assignment operator "=" and the commonplace ":="
Aug 28, 2022
postgresql
plpgsql
assignment-operator
colon-equals
SQL Sub queries in check constraint
Aug 28, 2022
postgresql
foreign-key-relationship
plpgsql
check-constraints
PostgreSQL - Iterate over results of query
Feb 21, 2022
sql
postgresql
plpgsql
Postgresql, update if row with some unique value exists, else insert
Aug 28, 2022
postgresql
triggers
plpgsql
DROP FUNCTION without knowing the number/type of parameters?
Aug 27, 2022
postgresql
plpgsql
dynamic-sql
sql-drop
Iterating over integer[] in PL/pgSQL
Aug 27, 2022
arrays
postgresql
loops
plpgsql
postgresql-8.4
How to write function for optional parameters in postgresql?
Aug 27, 2022
sql
postgresql
plpgsql
How can I execute pl/pgsql code without creating a function?
Aug 27, 2022
postgresql
plpgsql
PostgreSQL: How to DROP FUNCTION IF EXISTS without specifying parameters?
Aug 27, 2022
postgresql
plpgsql
How do I get the primary key(s) of a table from Postgres via plpgsql?
Aug 27, 2022
sql
postgresql
plpgsql
PL/pgSQL checking if a row exists
Oct 15, 2022
sql
postgresql
plpgsql
postgresql-9.1
exists
Loop over array dimension in plpgsql
Aug 26, 2022
arrays
postgresql
multidimensional-array
for-loop
plpgsql
« Newer Entries
Older Entries »