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