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 48C499DCA86 for ; Thu, 19 Jan 2006 12:45:49 -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 51363-10 for ; Thu, 19 Jan 2006 12:45:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail43.e.nsc.no (mail43.e.nsc.no [193.213.115.43]) by postgresql.org (Postfix) with ESMTP id 61BDE9DCA7B for ; Thu, 19 Jan 2006 12:45:45 -0400 (AST) Received: from [192.168.0.57] (062016183238.customer.alfanett.no [62.16.183.238]) (authenticated bits=0) by mail43.nsc.no (8.13.5/8.13.5) with ESMTP id k0JGjhaL022641 for ; Thu, 19 Jan 2006 17:45:44 +0100 (CET) From: "Leif B. Kristensen" 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 User-Agent: KMail/1.8.3 References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com> <324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com> <4f31e3850601190506s71a41cc9t@mail.gmail.com> In-Reply-To: <4f31e3850601190506s71a41cc9t@mail.gmail.com> X-Face: %iea8o"[SI'kMDS.`hz7lU=?\^lC9J-]CVjo; f{4-C:$?uVUEjyN~uYFn%*aH_c3d09U>=?utf-8?q?x=0A=09TXtaoj=7EMV=2E8PgG7hik9=3BcCT2N6+u?=@Y{wH\p3*_f~FH9k,Wi74e[_l%.7b^'zJ)8S'^G<(=?utf-8?q?=3D=0A=09zw8=5CPMC3=27=7BKl9=2EzL*ks!b6wA?=,c~'F`k&Vq|ELDGa|4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.03 required=5 tests=[AWL=0.030] X-Spam-Score: 0.03 X-Spam-Level: X-Archive-Number: 200601/133 X-Sequence-Number: 23922 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