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
SELECT or PERFORM in a PL/pgSQL function
Mar 29, 2022
postgresql
function
plpgsql
select-into
Calling a function that returns a refcursor
Mar 28, 2022
sql
postgresql
plpgsql
database-cursor
ref-cursor
What does "LANGUAGE plpgsql VOLATILE COST 100" mean in functions
Feb 14, 2022
postgresql
triggers
plpgsql
Execute deferred trigger only once per row in PostgreSQL
Apr 27, 2019
postgresql
database-design
triggers
plpgsql
Getting name of the current function inside of the function with plpgsql
Sep 29, 2022
postgresql
plpgsql
postgresql-9.1
pseudo_encrypt() function in plpgsql that takes bigint
May 31, 2020
sql
postgresql
plpgsql
PostgreSQL function or stored procedure that outputs multiple columns?
Sep 28, 2022
postgresql
stored-procedures
plpgsql
sql-function
How to set value of composite variable field using dynamic SQL
Sep 22, 2022
postgresql
stored-procedures
types
composite
plpgsql
Return SETOF rows from PostgreSQL function
Aug 21, 2020
postgresql
plpgsql
dynamic-sql
postgresql-9.2
Union of two arrays in PostgreSQL without unnesting
Sep 21, 2022
arrays
postgresql
union
plpgsql
Incrementing a number in a loop in plpgsql
Nov 16, 2022
sql
postgresql
increment
plpgsql
postgresql-8.4
How to md5 all columns regardless of type
Sep 26, 2022
sql
postgresql
md5
plpgsql
PostgreSQL function definition in SQuirreL: unterminated dollar-quoted string
Oct 01, 2019
sql
postgresql
plpgsql
squirrel-sql
Does Postgresql plpgsql/sql support short circuiting in the where clause?
Jul 17, 2018
sql
postgresql
plpgsql
Differences between ROWTYPE, TYPE, and RECORD in postgresql?
Sep 16, 2022
postgresql
plpgsql
rdbms
sqldatatypes
How to copy structure of one table to another with foreign key constraints in psql?
Jan 14, 2019
postgresql
foreign-keys
plpgsql
create-table
Escape function for regular expression or LIKE patterns
Sep 20, 2022
regex
postgresql
escaping
pattern-matching
plpgsql
How to execute PostgreSQL RAISE command dynamically
Sep 20, 2022
postgresql
exception-handling
plpgsql
Postgres function returning table not returning data in columns
Nov 03, 2018
sql
postgresql
plpgsql
postgresql-9.1
PostgreSQL - Language pgplsql does not exist despite running CREATE LANGUAGE
Sep 30, 2015
postgresql
plpgsql
« Newer Entries
Older Entries »