Problem running or executing a function in Postgresql

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

Responses

Browse pgsql-general by date

  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