Re: how do the pro's do this? (still a newbie) - Mailing list pgsql-general

From Gunnar Lindholm
Subject Re: how do the pro's do this? (still a newbie)
Date
Msg-id 01110309360802.11809@fire
Whole thread Raw
In response to Re: how do the pro's do this? (still a newbie)  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: how do the pro's do this? (still a newbie)
List pgsql-general
On Saturday 03 November 2001 09:32, you wrote:
> On Sat, Nov 03, 2001 at 08:34:37AM +0100, Gunnar Lindholm wrote:
> > I wrote a function similar to this and when inserting
> >  select foo('/new.html','194.165.2.24','2001-Oct-28 10:34:25+01');
> > it complains that
> > ERROR:  Attribute 'vad_seq' not found
> > "vad_seq" is a sequence just like "something" is in the example above.
> > The code I wrote is written below...  So if anybody can tell me what's
> > wrong, please do so. I find the error message very strange. I can't
> > believe that it can not find the sequence.... Shouldn't the sequence be
> > accessible from every function in that database?
>
> Well, my only suggestion is:
> >         ivad := nextval("vad_seq");
>
>                                 ^^^^^^^^^
>
> Should the name be in single quotes?
Then I get this error...
ERROR:  parser: parse error at or near "vad_seq"

so there is something I've done wrong, but I can't see....


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: how do the pro's do this? (still a newbie)
Next
From: Tatsuo Ishii
Date:
Subject: Re: CP1250 to and from Unicode conversion, how?