From: Susan Hoddinott <susan@hexworx.com>
To: pgsql-sql@postgresql.org
Subject: Create function statement with insert statement
Date: Wed, 12 Mar 2003 17:03:07 +0800
Message-ID: <003201c2e876$3498a880$1f84fea9@oemcomputer> (raw)
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
Attachments:
Susan Hoddinott.vcf (application/octet-stream, 170B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: susan@hexworx.com
Subject: Re: Create function statement with insert statement
In-Reply-To: <003201c2e876$3498a880$1f84fea9@oemcomputer>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox