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
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
Store regexp_matches result in variables
Jul 03, 2026
regex
postgresql
function
plpgsql
Trigger on UPDATE to DELETE rows in another table depending on a third table
Jul 02, 2026
postgresql
triggers
plpgsql
sql-delete
How to use PL/pgSQL to construct a table with dynamic columns
Jul 01, 2026
sql
postgresql
plpgsql
dynamic-sql
crosstab
Raise error without rollback in plpgsql/postgresql
Jul 01, 2026
postgresql
plpgsql
Similar UTF-8 strings for autocomplete field
Jun 29, 2026
postgresql
utf-8
plpgsql
string-comparison
similarity
How do you use LIKE query for enum in rails?
Jun 29, 2026
ruby-on-rails
ruby
plpgsql
pg-search
Postgresql - Compare a string with a null value
Jun 28, 2026
sql
postgresql
plpgsql
sql-null
Sanitize user input with the USING keyword in PL/pgSQL
Jun 26, 2026
sql
database
postgresql
plpgsql
dynamic-sql
How to print error message and line number in Postgres like DBMS_UTILITY.FORMAT_ERROR_BACKTRACE is on Oracle
Jun 23, 2026
postgresql
plpgsql
postgresql function - get number of rows affected by update query [duplicate]
Jun 22, 2026
sql
postgresql
function
plpgsql
postgresql-9.4
How do I drop all invalid indexes in postgres?
Jun 23, 2026
postgresql
indexing
plpgsql
reindex
Multiple select case in a select query
Jun 20, 2026
sql
postgresql
stored-procedures
plpgsql
select-case
Evaluation flow of multiple conditions in PostgreSQL
Jun 20, 2026
sql
postgresql
plpgsql
dynamic portion of plpgsql function
Jun 19, 2026
sql
postgresql
plpgsql
Postgres array of objects error `error: could not determine polymorphic type because input has type "unknown"`
Jun 18, 2026
arrays
json
postgresql
plpgsql
jsonb
PL/pgSQL : can't use variable on the right side of `in` operator
Jun 15, 2026
sql
postgresql
stored-procedures
plpgsql
dynamic order by sql postgresql
Jun 13, 2026
sql
postgresql
stored-procedures
plpgsql
« Newer Entries
Older Entries »