Dynamic Array into pl/pgSQL function

#11

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

Quote:

----- Original Message -----
From: "Joe Conway" <mail (AT) joeconway (DOT) com
To: "derrick" <derrick (AT) grifflink (DOT) com
Cc: <olly (AT) lfix (DOT) co.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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dynamic Array into pl/pgSQL function

comp.databases.postgresql.novice comp.databases.postgresql.novice

Fw: Dynamic Array into pl/pgSQL function - 06-01-2004 , 07:59 PM