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 write a function that returns text or integer values?
Jul 05, 2021
postgresql
types
plpgsql
postgresql-9.2
Return rows matching elements of input array in plpgsql function
Mar 21, 2017
arrays
postgresql
aggregate-functions
plpgsql
postgresql-9.2
Postgres bulk INSERT function using JSON arguments
Jun 22, 2022
sql
json
postgresql
plpgsql
sql-insert
track revisions in postgresql
Nov 13, 2022
postgresql
triggers
plpgsql
sql-function
revisions
PostgreSQL: get count of occurrences of specified element in array
Nov 02, 2022
sql
arrays
postgresql
plpgsql
How to delete table *or* view from PostgreSQL database?
Oct 21, 2022
postgresql
plpgsql
Get the count of rows from a COPY command
Apr 14, 2021
postgresql
count
plpgsql
sqlbulkcopy
How to get a list of stored procedures using a specific table in PostgreSQL?
Dec 18, 2019
database
postgresql
function
plpgsql
Raise and catch user defined exceptions
Nov 19, 2022
postgresql
exception-handling
plpgsql
postgresql round half down function
Oct 16, 2022
postgresql
floating-point
plpgsql
rounding
floating-accuracy
UPDATE a whole row in PL/pgSQL
Sep 22, 2022
postgresql
sql-update
plpgsql
Set a default return value for a Postgres function
Oct 26, 2022
sql
function
postgresql
if-statement
plpgsql
RETURN QUERY-Record in PostgreSQL
Oct 15, 2022
sql
postgresql
types
casting
plpgsql
Using %rowtype when returning in a PostgreSQL function
Nov 10, 2022
database
postgresql
plpgsql
Postgres Function to insert multiple records in two tables
Aug 20, 2022
sql
database
postgresql
plpgsql
postgresql-9.4
Getting transactionid(xid) from SQL
Jul 13, 2022
postgresql
transactions
plpgsql
identifier
Postgresql batch insert or ignore
Jul 25, 2019
sql
postgresql
plpgsql
postgresql-9.1
duplicate-removal
Can a function detect the trigger event type?
Oct 26, 2022
postgresql
triggers
plpgsql
Array of composite type as stored procedure input
Nov 18, 2022
arrays
postgresql
stored-procedures
plpgsql
unnest
Add element to empty array
Nov 22, 2021
postgresql
plpgsql
« Newer Entries
Older Entries »