From: Michael Glaesemann <grzm@myrealbox.com>
To: Leif B. Kristensen <leif@solumslekt.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: Fri, 20 Jan 2006 07:38:22 +0900
Message-ID: <930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com> (raw)
In-Reply-To: <200601191745.42918.leif@solumslekt.org>
References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
<324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
<4f31e3850601190506s71a41cc9t@mail.gmail.com>
<200601191745.42918.leif@solumslekt.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@myrealbox.com, leif@solumslekt.org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
In-Reply-To: <930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox