Re: Dynamic Array into pl/pgSQL function

Поиск
Список
Период
Сортировка
От Derrick Betts
Тема Re: Dynamic Array into pl/pgSQL function
Дата
Msg-id 40BC1F9B.105@BlueAxis.com
обсуждение исходный текст
Ответ на Re: Dynamic Array into pl/pgSQL function  (Joe Conway <mail@joeconway.com>)
Список pgsql-novice
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
>
>
>
>

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Ilya S. Slyzhnyak"
Дата:
Сообщение: wikipedia article
Следующее
От: Shawn Chisholm
Дата:
Сообщение: Ignoring an SQL INSERT error