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 return a table's rowtype plus an additional column from a function?
Feb 21, 2022
postgresql
plpgsql
return-type
set-returning-functions
How to disambiguate a plpgsql variable name in a ON CONFLICT clause?
Nov 17, 2022
sql
postgresql
plpgsql
upsert
name-conflict
PostgreSQL trigger not returning anything
Feb 19, 2019
postgresql
triggers
plpgsql
How to write combinatorics function in postgres?
Jun 21, 2022
postgresql
plpgsql
combinatorics
How to programmatically check if row is deletable?
Nov 11, 2020
sql
postgresql
database-design
plpgsql
sql-delete
Recursive function in postgres
Aug 27, 2022
postgresql
plpgsql
postgresql-9.2
recursive-query
SELECT usage with the new CREATE PROCEDURE method
Oct 31, 2022
postgresql
plpgsql
Perform action before exception call in Postgres trigger function
Aug 22, 2022
postgresql
exception
triggers
plpgsql
Returning set of rows from plpgsql function.
Oct 25, 2022
sql
postgresql
plpgsql
Trigger with dynamic field name
Aug 31, 2022
postgresql
triggers
plpgsql
dynamic-sql
postgresql-9.3
unaccent() does not work with Greek letters in plpgsql dynamic query
Jun 16, 2021
postgresql
plpgsql
dynamic-sql
accent-insensitive
unaccent
What does %% in PL/pgSQL mean?
Feb 23, 2022
sql
postgresql
plpgsql
PostgreSQL 9.3: isnumeric() in a condition
Dec 31, 2019
postgresql
plpgsql
postgresql-9.3
isnumeric
How to pass custom type array to Postgres function
Oct 29, 2022
php
sql
postgresql
postgresql-9.1
plpgsql
Running a SELECT in a PL/pgSQL block
Aug 28, 2022
postgresql
plpgsql
How to loop through split string
Mar 01, 2022
sql
postgresql
plpgsql
How to insert multiple rows using a function in PostgreSQL
Sep 25, 2022
function
postgresql
plpgsql
sql-insert
postgresql-9.3
PL/pgSQL column name the same as variable
Oct 15, 2022
postgresql
plpgsql
race-condition
uniqueidentifier
Column definitions in ROWS FROM() with multiple unnest calls
Oct 20, 2022
sql
arrays
postgresql
plpgsql
unnest
PostgreSQL function with a loop
Sep 25, 2022
function
postgresql
aggregate-functions
plpgsql
« Newer Entries
Older Entries »