X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1274047628E for ; Tue, 4 Mar 2003 13:52:34 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 71707-03 for ; Tue, 4 Mar 2003 13:52:29 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id B5D004762D3 for ; Tue, 4 Mar 2003 13:52:13 -0500 (EST) Received: from [216.135.165.74] (HELO lazarus) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP-TLS id 2879621; Tue, 04 Mar 2003 10:51:58 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Susan Hoddinott" , Subject: Re: Database function syntax for inserting records Date: Tue, 4 Mar 2003 09:31:14 -0800 User-Agent: KMail/1.4.3 References: <000901c2e1e5$cd7ee100$1f84fea9@oemcomputer> In-Reply-To: <000901c2e1e5$cd7ee100$1f84fea9@oemcomputer> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200303040931.14851.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/129 X-Sequence-Number: 12169 Susan, > which seems to me to be consistent with the instructions given in the > Reference manual. However, when trying to create this function I receive > the errors: > > parser: parse error at or near ";" > > parser: parse error at or near "orderinsert" What version of Postgres are you using? Create function syntax has change= d=20 through the various versions. --=20 Josh Berkus josh@agliodbs.com Aglio Database Solutions San Francisco