Tag: plpgsql


Found 234 results for 'plpgsql'.


1) postgresql - Variadic functions and composite types
2) postgresql - Trigger with IS DISTINCT FROM on rows with json/jsonb without comparison itemizing?
3) postgresql - PostgreSQL trigger function that selects from %current% table
4) postgresql - Postgresql trigger update whole table after delete
5) postgresql - Use trigger to synchronize columns with fields in json column on insert or update
6) postgresql - Should I write a scalar function or a setof returning function for an INSERT/UPDATE/DELETE which can return at most one row?
7) postgresql - Postgresql: How to pass an array to trigger function in TG_ARGV?
8) postgresql - Check whether empty strings are present in character-type columns
9) postgresql - Function Performance
10) postgresql - Dynamic Column Label in Postgres 9.5
11) postgresql - SELECT rows from table one by one, comparing one column values with values in an array
12) postgresql - Pass array of mixed type into stored FUNCTION
13) postgresql - Reuse SELECT query by adding results in array?
14) postgresql - Loop through slices of 2-dimensional array in plpgsql function?
15) postgresql - Passing array from one plpgsql function to another
16) postgresql - postgresql: mapping json array to string array
17) postgresql - CentOS 7, PostgreSQL failed to read permission data directory in mounted partition
18) postgresql - Basic transactional DDL script in PostgreSQL
19) postgresql - Case insensitive column names in a postgresql trigger function
20) postgresql - Column name as an argument of the function called in the trigger (PostgreSQL)
21) trigger - Pass Parameters to trigger function to execute dynamic SQL
22) postgresql - Trigger function using current row and current table name as variables
23) postgresql - Call multiple functions from trigger?
24) postgresql - Define recursive composite types
25) postgresql - Self-join unique pairs
26) postgresql - PostgreSQL and storing configs
27) postgresql - How to create function(table_name) that returns a set of the table
28) postgresql - Loop through key/value pairs of a jsonb object in postgresql function
29) postgresql - String handling in postgres 8.4
30) postgresql - Should Postgres function return/coerce numeric scale/precision?
31) postgresql - PL/pgsql: use cursor to update next record based on a condition from current record
32) postgresql - Concatenation of setof type or setof record
33) postgresql - Postgres plpgsql: Is a view better than a select query in a plpgsql function
34) postgresql - How to prevent a PostgreSQL trigger from being fired by another trigger?
35) postgresql - Trigger function taking column names as parameters to modify the row
36) postgresql - SQL injection in Postgres functions vs prepared queries
37) postgresql - Set var="NEW.this_word_column" in a trigger function if "word" is present in a column name
38) postgresql - Trigger function using current row and current table name as variables (final part)
39) postgresql - PostgreSQL use NEW in query for INSTEAD OF trigger
40) postgresql - plpgsql function to replace ' ' with null after insert using a trigger
41) postgresql - How to access NEW or OLD field given only the field's name?
42) trigger - Execute dynamic INSERT ON CONFLICT DO UPDATE in plpgsql function
43) postgresql - Assign to NEW by key in a Postgres trigger
44) postgresql - PostgreSQL procedural languages - differences between PL/pgSQL and SQL
45) postgresql - Postgresql function to create table
46) postgresql - How to get max field value length for each TEXT field in all tables in database
47) postgresql - How to use function parameters in dynamic SQL with EXECUTE?
48) postgresql - Try catch equivalent in Postgres
49) postgresql - How to cast to int array in Postgresql?
50) postgresql - Joining a function and a view