Create function statement with insert statement

From: "Susan Hoddinott" <susan(at)hexworx(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Create function statement with insert statement
Date: 2003-03-12 09:03:07
Message-ID: 003201c2e876$3498a880$1f84fea9@oemcomputer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Attachment Content-Type Size
Susan Hoddinott.vcf application/octet-stream 171 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Susan Hoddinott 2003-03-12 09:11:19 Using update statements in create function statements
Previous Message Christoph Haller 2003-03-12 08:14:20 Re: Special characters in SQL queries