Problem running or executing a function in Postgresql
От | Venki |
---|---|
Тема | Problem running or executing a function in Postgresql |
Дата | |
Msg-id | 43169F8B.00000A.00960@VENKI обсуждение исходный текст |
Ответы |
Re: Problem running or executing a function in Postgresql
Re: Problem running or executing a function in Postgresql |
Список | 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 as declare new_id integer; begin INSERT new_id = EXECUTE("SELECT FROM currval("mydata_id_seq")"); return new_id; end; ' LANGUAGE
when I run the function as select
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 | |||
В списке pgsql-general по дате отправления: