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 create sequence if not exists
Sep 16, 2022
sql
postgresql
database-design
plpgsql
postgresql-9.2
PostgreSQL cannot begin/end transactions in PL/pgSQL
Sep 22, 2022
postgresql
stored-procedures
transactions
plpgsql
postgresql-9.2
Refactor a PL/pgSQL function to return the output of various SELECT queries
Aug 31, 2022
sql
database
postgresql
plpgsql
dynamic-sql
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
« Newer Entries
Older Entries »