Tag: functions


Found 414 results for 'functions'.


1) postgresql - How to map similar camelcased, pascalcased, underscored, lowerscored words to the same id?
2) postgresql - Inserting into a table a row represented by JSON
3) postgresql - SQL Error [42883] - function does not exist - Cannot call function from trigger
4) postgresql - How to create `instead of` trigger on a table in postgres?
5) postgresql - Variadic functions and composite types
6) postgresql-9.4 - Loop over string literals as input to function PostgreSQL 9.4
7) postgresql - Proper use of database functions for business logic
8) postgresql - Function that loops through array parameter values to build multiple WHERE clauses (postgres 11.4)
9) postgresql - PostgreSQL trigger function that selects from %current% table
10) postgresql - Postgresql trigger update whole table after delete
11) sql-server - Efficiency of Scalar UDF vs TVF
12) postgresql - In PostgreSQL, what is the difference between a "Stored Procedure" and other types of functions?
13) postgresql - Should I write a scalar function or a setof returning function for an INSERT/UPDATE/DELETE which can return at most one row?
14) postgresql - How to select sub-object with given keys from JSONB?
15) postgresql - PostgreSQL: Pass table as argument in function
16) sql-server - Are the results of the STRING_SPLIT() function returned in a deterministic order?
17) postgresql - When to mark functions as PARALLEL RESTRICTED vs PARALLEL SAFE?
18) postgresql - How to create a postgres function that returns a value
19) postgresql - Pass array of mixed type into stored 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 - Postgres Trigger function - Pg 9.1
23) postgresql - Call multiple functions from trigger?
24) sql-server - Creating a helper UDF or stored procedure and limiting external access
25) sql-server - Why high compile times for functions with XML on SQL Server 2016?
26) postgresql - Is there any performance advantage to marking a SQL function as LEAKPROOF?
27) postgresql - Is this temp table behaviour documented?
28) postgresql - Update record with converted epoch timestamp from another column
29) postgresql - How to use aes-encryption in PostgreSQL?
30) postgresql - list of PostgreSQL trusted languages?
31) postgresql - Postgresql 9.6 Error trying to have a function return a string without first casting it as a string.
32) postgresql - Is there any way in Postgres to parameterise a procedure for sort order column, when the columns are of different types?
33) postgresql - Transform all columns records to lowercase
34) postgresql - How to create function(table_name) that returns a set of the table
35) postgresql - Postgres : Executing SELECT within a transaction does not return most recent rows
36) postgresql - Should Postgres function return/coerce numeric scale/precision?
37) postgresql - Equivalent of DB2 function "decimal(numeric expression, precision, scale)" in PostgreSQL
38) postgresql - How to create a table dynamically based on json data?
39) postgresql - Recursive update for tree structure in PostgreSQL
40) postgresql - In a Postgres function, how to skip expressions if input value is null?
41) postgresql - PostgreSQL function to insert to table from another table has different structure
42) postgresql - How to pass a parameter into a function
43) postgresql - SQL injection in Postgres functions vs prepared queries
44) postgresql - Using newly inserted values in trigger function in PostgreSQL
45) postgresql - Assign to NEW by key in a Postgres trigger
46) postgresql - SUM() the result of a function
47) c# - Correct usage of Property vs Field vs Function in C#
48) design-patterns - Are first-class functions a substitute for the Strategy pattern?
49) naming - Boolean Method Naming Affirmative vs Negative
50) php - How to split a Service class in two but still use them like one?