Re: how do the pro's do this? (still a newbie)

From: Gunnar Lindholm <gunnar(at)gunix(dot)mine(dot)nu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how do the pro's do this? (still a newbie)
Date: 2001-11-03 08:36:08
Message-ID: 01110309360802.11809@fire
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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....

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy 2001-11-03 10:02:45 Porting Web application written in Oracle 8 PL/SQL to Postgresql
Previous Message Martijn van Oosterhout 2001-11-03 08:32:09 Re: how do the pro's do this? (still a newbie)