Fw: Dynamic Array into pl/pgSQL function
От | derrick@grifflink.com |
---|---|
Тема | Fw: Dynamic Array into pl/pgSQL function |
Дата | |
Msg-id | 003b01c4483c$e6f99350$0200a8c0@main обсуждение исходный текст |
Список | 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@joeconway.com> > To: "derrick" <derrick@grifflink.com> > Cc: <olly@lfix.co.uk>; <pgsql-novice@postgresql.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 > > > > > > >
В списке pgsql-novice по дате отправления: