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

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: 2006-01-19 22:38:22
Message-ID: 930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Juris 2006-01-20 06:52:47 Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Previous Message Leif B. Kristensen 2006-01-19 16:45:42 Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"