plpgsql is case insensitive : plpgsql « Postgre SQL « PostgreSQL






plpgsql is case insensitive


postgres=# CREATE FUNCTION "mixed" () RETURNS integer AS '
postgres'#        DecLarE
postgres'#           --assigns 1 to the oNe variable
postgres'#           oNe IntEgER
postgres'#           := 1;
postgres'#
postgres'#        bEGiN
postgres'#
postgres'#           --displays the value of oNe
postgres'#           ReTUrn oNe;
postgres'#        eNd;
postgres'#        ' LANGUAGE 'plpgsql';
CREATE FUNCTION
postgres=#
postgres=# select mixed();
 mixed
-------
     1
(1 row)

postgres=#
           
       








Related examples in the same category