Postgres Pro
Downloads
Home   >   mailing lists

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

From Leif B. Kristensen
Subject Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date
Msg-id 200601191745.42918.leif@solumslekt.org
Whole thread Raw
In response to Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"  (Juris <bubliks@gmail.com>)
Responses Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-sql
Tree view 
On Thursday 19 January 2006 14:06, Juris wrote:
>Argh... big thanks.. did not know what pgAdmin/PG have any
>case-sensitive issues with functions...
>
>Also for fields it is relative... without dbl-quotes i could not query
>anything (i am using "MySuperField"-like field names)

That is usual behaviour for RDBMSes. They are case-insensitive if you 
use ALL_CAPS or small_letters only. But if you use CamelCasing (which 
is the canonical name of this style), you're actually the one who 
imposes a case-sensitiveness upon the DB interpreter. So, the advice 
usually goes to avoid CamelCasing like the plague.

regards,
-- 
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: indexing for left join
Next
From: T E Schmitz
Date:
Subject: Re: indexing for left join