You were absolutely right! I just installed 7.4.2 and assumed that it was
the system that we were running. There was an error, and so the database
was re-installed. All is great now.
Thanks everyone for your insights.
Derrick
> ----- Original Message -----
> From: "Joe Conway" <mail@joeconway.com>
> To: "derrick" <derrick@grifflink.com>
> Cc: <olly@lfix.co.uk>; <pgsql-novice@postgresql.org>
> Sent: Monday, May 31, 2004 5:53 PM
> Subject: Re: [NOVICE] Dynamic Array into pl/pgSQL function
>
>
> > derrick wrote:
> > > There must be some kind of setting that needs to be set on my database
> that
> > > isn't, because I have copied what you used nearly exactly, and I still
> get
> > > this message: "WARNING: line 4 at for over select rows ERROR:
parser:
> > > parse error at or near "$1" at character 55"
> >
> > [...snip example...]
> > > Any other ideas? I'm using 7.4.2
> >
> > I'd bet not. Show us the result of:
> >
> > select version();
> >
> > Your example works perfectly for me under 7.4.2, and gives the same
> > error you see under 7.3.6.
> >
> > HTH,
> >
> > Joe
> >
> >
> >
>
