Fw: Dynamic Array into pl/pgSQL function

From: derrick(at)grifflink(dot)com
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Fw: Dynamic Array into pl/pgSQL function
Date: 2004-06-02 00:59:47
Message-ID: 003b01c4483c$e6f99350$0200a8c0@main
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)joeconway(dot)com>
> To: "derrick" <derrick(at)grifflink(dot)com>
> Cc: <olly(at)lfix(dot)co(dot)uk>; <pgsql-novice(at)postgresql(dot)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
> >
> >
> >
>

Browse pgsql-novice by date

  From Date Subject
Next Message Rajan Bhide 2004-06-03 06:08:57 Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
Previous Message Derrick Betts 2004-06-01 06:18:03 Re: Dynamic Array into pl/pgSQL function