From: Juris <bubliks@gmail.com>
To: Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: Fri, 20 Jan 2006 08:52:47 +0200
Message-ID: <4f31e3850601192252md973d4fs@mail.gmail.com> (raw)
In-Reply-To: <930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com>
References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
<324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
<4f31e3850601190506s71a41cc9t@mail.gmail.com>
<200601191745.42918.leif@solumslekt.org>
<930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com>
Jep... but pgAdmin_III inserts dbl-quotes, if there is some
CamelCase... but from sql-console i can create objects w/ or w/o
dbl-quotes, but in result i always get lower-cased objects..
Seems, i should `recreate` my db in lowercase.. it will take some time :(
Thanks for advance.
PS: problem here is that, then i initialize row in PHP, i do $row =
$dbio->object($res)...
and PHP variables/object_properties ar case-sensitive...
2006/1/20, Michael Glaesemann <grzm@myrealbox.com>:
>
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
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: bubliks@gmail.com, grzm@myrealbox.com
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
In-Reply-To: <4f31e3850601192252md973d4fs@mail.gmail.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