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

From Joe Conway
Subject Re: Dynamic Array into pl/pgSQL function
Date
Msg-id 40BBC567.7090401@joeconway.com
Whole thread Raw
In response to Re: Dynamic Array into pl/pgSQL function  ("derrick" <derrick@grifflink.com>)
Responses Re: Dynamic Array into pl/pgSQL function
List pgsql-novice
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: "derrick"
Date:
Subject: Re: Dynamic Array into pl/pgSQL function
Next
From: David Cruz
Date:
Subject: Hi!, help with this new type