PostgreSQL Store Procedure Function 25 codes

  1. Home
  2. PostgreSQL
  3. Store Procedure Function
1 A SQL function that returns a book title based on the ID number passed to the function
2 Add three parameters together in a function
3 Anyelement parameter
4 Call function in select statement
5 Case insensitive
6 Create a simeple function
7 Declare Input alias
8 Define function to add two parameters together
9 Drop a function
10 Functions with Output Parameters
11 Here the $1 references the value of the first function argument whenever the function is invoked
12 OUT parameter
13 Output parameters are most useful when returning multiple values
14 Pass constant to function
15 Pass in a whole row
16 Pass in entire table row to a function
17 Real number parameter
18 Return a table from a function
19 Return double from function
20 Return entire row
21 Returning a concatenated string
22 The simplest possible SQL function has no arguments and simply returns a base type
23 Two out parameters
24 Use defined data type as the function parameter
25 Using the result set returned from the function