From: | "Venki" <Venki(at)insoft(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem running or executing a function in Postgresql |
Date: | 2005-09-01 06:28:27 |
Message-ID: | 43169F8B.00000A.00960@VENKI |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a table named mydata
CREATE TABLE public.mydata (
id int4 DEFAULT nextval('public.mydata_id_seq'::text) NOT NULL,
name varchar(50)
) WITH OIDS;
and I have a function as follows
CREATE OR REPLACE FUNCTION insertmydata(varchar) RETURNS int
as '
declare
new_id integer;
begin
INSERT INTO mydata("name") values($1);
new_id = EXECUTE("SELECT FROM currval("mydata_id_seq")");
return new_id;
end;
'
LANGUAGE 'PLPGSQL';
when I run the function as
select insertmydata('Venkatesh')
I am getting the following error message
"ERROR: syntax error at or near "mydata_id_seq" at character 39"
can anyone help me in solving the above problem. Am I missing something
here? How should I run the function to insert data?
I am using postgresql version 7.4.6 in a linux box and running pgadmin from
a Winxp PC.
Kind Regards,
Venki
From | Date | Subject | |
---|---|---|---|
Next Message | David Sankel | 2005-09-01 08:52:55 | Re: Removing all users from a group |
Previous Message | Gordon | 2005-09-01 06:26:30 | Re: shared_buffers + Windows |