X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1D6D85E46F2 for ; Thu, 26 Aug 2004 10:27:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49319-08 for ; Thu, 26 Aug 2004 13:27:35 +0000 (GMT) Received: from dswu28.btconnect.com (dswu28.btconnect.com [193.113.154.29]) by svr1.postgresql.org (Postfix) with SMTP id C7D6E5E46EE for ; Thu, 26 Aug 2004 10:27:32 -0300 (ADT) Received: from kwest2.local (actually host 143.83.35.217.in-addr.arpa) by dswu28 with SMTP-CUST (XT-PP) with ESMTP; Thu, 26 Aug 2004 14:27:36 +0100 Received: from Kieran (unknown [192.168.0.140]) by kwest2.local (Postfix) with SMTP id 3E0C82B1AB for ; Thu, 26 Aug 2004 14:30:12 +0100 (BST) Message-ID: <000901c48b70$8c70d7a0$8c00a8c0@Kieran> From: "Kieran McCusker" To: Subject: Loading functions Date: Thu, 26 Aug 2004 14:28:17 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2741.2600 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2742.200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/286 X-Sequence-Number: 14681 Hi My biggest bugbear with Postgresql is the double quoting when writing functions. Has anyone suggested a possible syntax such as :- create or replace function sp_AddContact(varchar) returns integer from '' LANGUAGE 'plpgsql'; This would remove the issue with parsing for begin...ends (or whatever the language was using) Just a thought Kieran