Re: Dynamic Array into pl/pgSQL function - Mailing list pgsql-novice

From Derrick Betts
Subject Re: Dynamic Array into pl/pgSQL function
Date
Msg-id 40BC1F9B.105@BlueAxis.com
Whole thread Raw
In response to Re: Dynamic Array into pl/pgSQL function  (Joe Conway <mail@joeconway.com>)
List pgsql-novice
You are absolutely right!  I installed 7.4.2 on the server but for some
reason (My lack of experience) I was still using 7.3.2 thinking I was
using the new version.  The problem has been rectified, and we are now
on 7.4.2 and the array feature works perfectly.  Thanks to everyone for
your help.

Derrick

Joe Conway wrote:

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

pgsql-novice by date:

Previous
From: "Ilya S. Slyzhnyak"
Date:
Subject: wikipedia article
Next
From: Shawn Chisholm
Date:
Subject: Ignoring an SQL INSERT error