Re: [GENERAL] CREATE FUNCTION Fails with an Insert Statement in it

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 11:51:00 -0500 mailte Jasbinder Singh Bali folgendes: > I have created the following function : > > > CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text) > RETURNS bool AS > $BODY$ > INSERT INTO tbl_xyz > (unmask_id,email_from) > VALUES ($1,$2) > $BODY$ >

Re: [GENERAL] CREATE FUNCTION Fails with an Insert Statement in it

2007-01-23 Thread Merlin Moncure
On 1/23/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: I have created the following function : CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text) RETURNS bool AS $BODY$ INSERT INTO tbl_xyz (unmask_id,email_from) VALUES ($1,$2) $BODY$ LANGUAGE 'sql' VOLATILE; when i try to c

[GENERAL] CREATE FUNCTION Fails with an Insert Statement in it

2007-01-23 Thread Jasbinder Singh Bali
I have created the following function : CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text) RETURNS bool AS $BODY$ INSERT INTO tbl_xyz (unmask_id,email_from) VALUES ($1,$2) $BODY$ LANGUAGE 'sql' VOLATILE; when i try to create this fucntion by running this script, i get the following