Re: Dynamic Array into pl/pgSQL function

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