Newbie ...Function error (Stored Procedure)? - Mailing list pgsql-general

From zhi7c001@sneakemail.com (Ron S)
Subject Newbie ...Function error (Stored Procedure)?
Date
Msg-id 18069d11.0108271134.581892da@posting.google.com
Whole thread Raw
Responses Re: Newbie ...Function error (Stored Procedure)?  (Richard Poole <richard.poole@vi.net>)
List pgsql-general
I have a sequence called seq1.

In psql I am trying to create a function which simply calls this
sequence with the nextval() function.

CREATE FUNCTION testid()
RETURNS INTEGER
AS 'SELECT NEXTVAL('seq1');'
LANGUAGE 'SQL';


I get the following error....
ERROR:  parser: parser error at or near "seq1"

I can call nextval('seq1') by itself with now error.

What am I doing wrong? I can't for the life of me figure this
seemingly simple
error out ;)

Postgresql 7.0.3 on Mandrake 8.0

Thanks,
Ron

pgsql-general by date:

Previous
From: Israel Evans
Date:
Subject: PostgreSQL On the Mac? OS9 or OSX?
Next
From: "Corn"
Date:
Subject: Questions about unicode.