Re: Newbie ...Function error (Stored Procedure)?
От | Jeff Eckermann |
---|---|
Тема | Re: Newbie ...Function error (Stored Procedure)? |
Дата | |
Msg-id | 053c01c13264$702cd7f0$279c10ac@INTERNAL обсуждение исходный текст |
Ответ на | Newbie ...Function error (Stored Procedure)? (zhi7c001@sneakemail.com (Ron S)) |
Список | pgsql-general |
I think you need to double the single quotes around the sequence name: (''seq1''). Statements inside function definitions go through an extra level of parsing, which strips off one set of single quotes. ----- Original Message ----- From: "Ron S" <zhi7c001@sneakemail.com> To: <pgsql-general@postgresql.org> Sent: Monday, August 27, 2001 2:34 PM Subject: [GENERAL] Newbie ...Function error (Stored Procedure)? > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
В списке pgsql-general по дате отправления: