Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Glaesemann
Subject Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date
Msg-id 930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com
Whole thread Raw
In response to Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"  ("Leif B. Kristensen" <leif@solumslekt.org>)
Responses Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"  (Juris <bubliks@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: T E Schmitz
Date:
Subject: Re: indexing for left join
Next
From: Juris
Date:
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"