Re: how do the pro's do this? (still a newbie) - Mailing 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....