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
> >
> >
> >
>
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 |