From: | "Ian Harding" <ianh(at)tpchd(dot)org> |
---|---|
To: | <jong(at)e88(dot)org>, <susan(at)hexworx(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Create function statement with insert statement |
Date: | 2003-03-13 14:45:19 |
Message-ID: | se70295c.026@mail.tpchd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I think the language needs to be in quotes ...
...
' language 'sql';
>>> "Jon Griffin" <jong(at)e88(dot)org> 03/12/03 11:59AM >>>
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Gamache | 2003-03-13 14:52:26 | Re: "hide" values in a column |
Previous Message | Christoph Haller | 2003-03-13 14:12:47 | Re: What's wrong with this group by clause? |