Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"

On Jan 20, 2006, at 1:45 , Leif B. Kristensen wrote:

> That is usual behaviour for RDBMSes. They are case-insensitive if you
> use ALL_CAPS or small_letters only.

PostgreSQL is case-insensitive in the sense that it down-cases  
identifiers that are not double-quoted, e.g.,

MYSUPERFIELD -> mysuperfield
MySuperField -> mysuperfield
mysuperfield -> mysuperfield

"MYSUPERFIELD" -> MYSUPERFIELD
"MySuperField" -> "MySuperField"
"mysuperfield" -> mysuperfield

Michael Glaesemann
grzm myrealbox com