Postgres Pro
Downloads
Home   >   mailing lists

Create function statement with insert statement - Mailing list pgsql-sql

From Susan Hoddinott
Subject Create function statement with insert statement
Date
Msg-id 003201c2e876$3498a880$1f84fea9@oemcomputer
Whole thread Raw
Responses Re: Create function statement with insert statement  ("Jon Griffin" <jong@e88.org>)
Re: Create function statement with insert statement  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: August Detlefsen
Date:
Subject: Using column alias in WHERE clause?
Next
From: "Susan Hoddinott"
Date:
Subject: Using update statements in create function statements