From: | Juris <bubliks(at)gmail(dot)com> |
---|---|
To: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" |
Date: | 2006-01-20 06:52:47 |
Message-ID: | 4f31e3850601192252md973d4fs@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)myrealbox(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schaber | 2006-01-20 10:56:10 | Re: Error calling self-made plpgsql function "function XYZ(bigint) |
Previous Message | Michael Glaesemann | 2006-01-19 22:38:22 | Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" |