From: Leif B. Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: Thu, 19 Jan 2006 17:45:42 +0100
Message-ID: <200601191745.42918.leif@solumslekt.org> (raw)
In-Reply-To: <4f31e3850601190506s71a41cc9t@mail.gmail.com>
References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
<324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
<4f31e3850601190506s71a41cc9t@mail.gmail.com>
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
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: leif@solumslekt.org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
In-Reply-To: <200601191745.42918.leif@solumslekt.org>
* 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