Case insensitive : Create Function « Store Procedure Function « PostgreSQL






  1. PostgreSQL
  2. Store Procedure Function
  3. Create Function

Case insensitive

postgres=#
postgres=# CREATE FUNCTION "first" () RETURNS integer AS '
postgres'#        DecLarE
postgres'#         oNe IntEgER := 1;
postgres'#        bEGiN
postgres'#         ReTUrn oNE;
postgres'#        eNd;
postgres'# ' LANGUAGE 'plpgsql';
CREATE FUNCTION
postgres=#
postgres=# select first();
 first
-------
     1
(1 row)

postgres=#








Related examples in the same category

1.Create a simeple function
2.Add three parameters together in a function
3.Functions with Output Parameters
4.Pass in entire table row to a function
5.The simplest possible SQL function has no arguments and simply returns a base type