X-Original-To: pgsql-sql@postgresql.org Received: from zuma.wtgcom.com (unknown [208.48.171.162]) by postgresql.org (Postfix) with ESMTP id A382F476364 for ; Wed, 12 Mar 2003 14:59:08 -0500 (EST) Received: (qmail 31218 invoked by uid 204); 12 Mar 2003 20:21:02 -0000 Received: from jong@e88.org by zuma.wtgcom.com by uid 1000 with qmail-scanner-1.15 (sweep: 2.10/3.65. Clear:. Processed in 0.851738 secs); 12 Mar 2003 20:21:02 -0000 X-Qmail-Scanner-Mail-From: jong@e88.org via zuma.wtgcom.com X-Qmail-Scanner: 1.15 (Clear:. Processed in 0.851738 secs) Received: from unknown (HELO mayuli.com) (192.168.1.202) by 0 with SMTP; 12 Mar 2003 20:21:01 -0000 Received: from 192.168.1.12 (proxying for 129.219.231.66) (SquirrelMail authenticated user jon_clean@mayuli.com) by mail.mayuli.com with HTTP; Wed, 12 Mar 2003 11:59:12 -0800 (PST) Message-ID: <38008.192.168.1.12.1047499152.squirrel@mail.mayuli.com> Date: Wed, 12 Mar 2003 11:59:12 -0800 (PST) Subject: Re: Create function statement with insert statement From: "Jon Griffin" To: In-Reply-To: <003201c2e876$3498a880$1f84fea9@oemcomputer> References: <003201c2e876$3498a880$1f84fea9@oemcomputer> X-Priority: 3 Importance: Normal Cc: X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200303/306 X-Sequence-Number: 12345 You need to put your aliases in: value1 alias for $1; etc. Hello, > > I am trying to create a database trigger which inserts into a second > table. I have created the following function in accordance with the > reference manual documentation (7.2). > > > CREATE OR REPLACE FUNCTION orderinsert(INTEGER, VARCHAR) RETURNS INTEGER > AS ' > > INSERT INTO HEXORDERS ( CUSTOMER_ID, ORDER_KEY, DISTRIBUTOR_ID, > ORDER_AMOUNT, ORDER_GST ) VALUES ( $1, $2, 1, 0, 0 ) ; > > SELECT 1 ; > > ' LANGUAGE SQL ; > > > > It fails with the cryptic error "parse error at or near ;". Can anyone > tell me what is wrong with this syntax? > > Regards