Re: Dynamic Array into pl/pgSQL function

Поиск
Список
Период
Сортировка
Искать
От
Joe Conway
Тема
Re: Dynamic Array into pl/pgSQL function
Дата
в 20:53:23
Msg-id
40BBC567.7090401@joeconway.com
Ответ на
Список
Дерево обсуждения
Dynamic Array into pl/pgSQL function "Derrick Betts" <derrick@grifflink.com>
Re: Dynamic Array into pl/pgSQL function "derrick" <derrick@grifflink.com>
Re: Dynamic Array into pl/pgSQL function Oliver Elphick <olly@lfix.co.uk>
Re: Dynamic Array into pl/pgSQL function "derrick" <derrick@grifflink.com>
Re: Dynamic Array into pl/pgSQL function Oliver Elphick <olly@lfix.co.uk>
Re: Dynamic Array into pl/pgSQL function Oliver Elphick <olly@lfix.co.uk>
Re: Dynamic Array into pl/pgSQL function "derrick" <derrick@grifflink.com>
Hi!, help with this new type David Cruz <davidcrmail@yahoo.com>
Re: Hi!, help with this new type Tom Lane <tgl@sss.pgh.pa.us>
Re: Dynamic Array into pl/pgSQL function Joe Conway <mail@joeconway.com>
Re: Dynamic Array into pl/pgSQL function Derrick Betts <derrick@BlueAxis.com>
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 по дате отправления
От: derrick
Дата:
От: David Cruz
Дата:
Сообщение: Hi!, help with this new type
FAQ