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 8B07D9DC9A2 for ; Thu, 19 Jan 2006 18:38:24 -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 26343-03 for ; Thu, 19 Jan 2006 18:38:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [151.155.5.143]) by postgresql.org (Postfix) with ESMTP id 5E38B9DC98F for ; Thu, 19 Jan 2006 18:38:22 -0400 (AST) Received: from [172.16.1.181] grzm [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux; Thu, 19 Jan 2006 15:38:24 -0700 In-Reply-To: <200601191745.42918.leif@solumslekt.org> References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com> <324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com> <4f31e3850601190506s71a41cc9t@mail.gmail.com> <200601191745.42918.leif@solumslekt.org> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <930C66CA-730E-4B44-AAC3-0149D528F9CE@myrealbox.com> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Date: Fri, 20 Jan 2006 07:38:22 +0900 To: "Leif B. Kristensen" X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.072 required=5 tests=[AWL=-0.260, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.072 X-Spam-Level: * X-Archive-Number: 200601/136 X-Sequence-Number: 23925 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