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

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?

HTH,
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.