X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 737B49DC85B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 20 Jan 2006 02:53:05 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 21193-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 20 Jan 2006 02:53:05 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197])
	by postgresql.org (Postfix) with ESMTP id 48AC69DC83F
	for <pgsql-sql@postgresql.org>; Fri, 20 Jan 2006 02:53:02 -0400 (AST)
Received: by zproxy.gmail.com with SMTP id 14so403440nzn
	for <pgsql-sql@postgresql.org>; Thu, 19 Jan 2006 22:53:03 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=n9B4xK2mWeKCEOubvUtBaBjux7R32OpAWNCF1X/dnkCJvnCpnWYvyUmWU98+RLMbrmN4jjE8TsOvGP9c+3uUrdmCaHZqCBifu2YLuBGDO0lARGeXMRV0YE1Mjwu9WtzR+2kGFFSPbJLwSHReGE1JxsvOrbI5B1ts706g7bNWQ3w=
Received: by 10.64.250.3 with SMTP id x3mr1118642qbh;
	Thu, 19 Jan 2006 22:52:47 -0800 (PST)
Received: by 10.65.212.8 with HTTP; Thu, 19 Jan 2006 22:52:47 -0800 (PST)
Message-ID: <4f31e3850601192252md973d4fs@mail.gmail.com>
Date: Fri, 20 Jan 2006 08:52:47 +0200
From: Juris <bubliks@gmail.com>
To: Michael Glaesemann <grzm@myrealbox.com>
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint)
	does not exist"
Cc: pgsql-sql@postgresql.org
In-Reply-To: <930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
	<324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
	<4f31e3850601190506s71a41cc9t@mail.gmail.com>
	<200601191745.42918.leif@solumslekt.org>
	<930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
X-Spam-Score: 0.12
X-Spam-Level: 
X-Archive-Number: 200601/137
X-Sequence-Number: 23926

Jep... but  pgAdmin_III inserts dbl-quotes, if there is some=20
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 =3D
$dbio->object($res)...
and PHP variables/object_properties ar case-sensitive...

2006/1/20, Michael Glaesemann <grzm@myrealbox.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
>