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
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
Any difference in performance/compatibility of different languages in PostgreSQL?
Nov 05, 2021
database
postgresql
stored-procedures
plpgsql
How to use variable settings in trigger functions?
Sep 18, 2022
postgresql
global-variables
plpgsql
postgresql-triggers
Inserting NEW.* from a generic trigger using EXECUTE in PL/pgsql
Dec 17, 2017
postgresql
triggers
plpgsql
Function to loop through and select data from multiple tables
Nov 06, 2022
postgresql
for-loop
plpgsql
dynamic-sql
set-returning-functions
Return dynamic table with unknown columns from PL/pgSQL function
Sep 05, 2022
postgresql
polymorphism
plpgsql
dynamic-sql
return-type
« Newer Entries
Older Entries »