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
Postgresql Common Expression Table (CTE) in Function
Jul 31, 2026
postgresql
stored-procedures
syntax-error
plpgsql
common-table-expression
How to exit from plpgsql function while returning query
Jul 29, 2026
postgresql
plpgsql
How to output "explain analyze" result to a table column?
Jul 27, 2026
postgresql
plpgsql
postgresql-9.3
sql-execution-plan
explain
Finding mean, standard deviation ,percentiles for all numeric variables in table
Jul 26, 2026
sql
postgresql
stored-procedures
plpgsql
greenplum
Truncate if exists in psql function and call function
Jul 26, 2026
sql
postgresql
plpgsql
truncate
search-path
Create a function in PostgreSQL
Jul 26, 2026
sql
database
postgresql
function
plpgsql
Caching when using a loop in PL/pgSQL
Jul 24, 2026
postgresql
caching
postgis
plpgsql
Before insert trigger to replace new data postgres
Jul 23, 2026
postgresql
plpgsql
database-trigger
PostgreSQL return table with update and select statement causing ambiguity
Jul 20, 2026
postgresql
sql-update
plpgsql
PostgreSQL: Checking for NEW and OLD in a function for a trigger
Jul 18, 2026
postgresql
plpgsql
database-trigger
postgresql-9.5
postgresql run external sql script from inside function
Jul 16, 2026
postgresql
plpgsql
Can I iterate over NEW in a PostgreSQL trigger function?
Jul 17, 2026
postgresql
triggers
plpgsql
dynamic-sql
How to XML-encode a string in PostgreSQL?
Jul 14, 2026
postgresql
plpgsql
postgresql-9.1
postgresql-9.2
Adding ST_Transform in a PL/pgSQL function
Jul 12, 2026
sql
postgresql
postgis
plpgsql
coordinate-transformation
PostgreSQL 9.3 trigger function to insert into table with parameterized name
Jul 09, 2026
postgresql
triggers
plpgsql
dynamic-sql
PostgreSQL trigger prevents another one to work
Jul 10, 2026
postgresql
triggers
plpgsql
database-trigger
Splitting comma separated string in PL/pgSQL function
Jul 08, 2026
sql
postgresql
plpgsql
Trying to create aggregate function in PostgreSQL
Jul 05, 2026
postgresql
aggregate-functions
plpgsql
In PostgreSQL, how can you declare a variadic function that accepts arguments of differing types?
Jul 03, 2026
postgresql
plpgsql
PostgreSQL: `unnest` an array and then `array_agg` it back
Jul 03, 2026
postgresql
plpgsql
Older Entries »