Re: arrays and functions in plpgsql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: arrays and functions in plpgsql
Дата
Msg-id 26819.1095466248@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: arrays and functions in plpgsql  (Todd Kover <kovert@omniscient.com>)
Ответы Re: arrays and functions in plpgsql  (Todd Kover <kovert@omniscient.com>)
Список pgsql-novice
Todd Kover <kovert@omniscient.com> writes:
>         v_state[3] float8;

Hmm.  I'm not sure what the plpgsql parser will make of that.  I think
you probably wanted
          v_state float8[3];

(note that you really want [4], not that it actually matters since PG
doesn't enforce the array size; float8[] would do as well)

Also, I think you need to change v_state to v_old_state in several more
places than you did, or else assign v_old_state to v_state up front.

            regards, tom lane

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

Предыдущее
От: Todd Kover
Дата:
Сообщение: Re: arrays and functions in plpgsql
Следующее
От: Todd Kover
Дата:
Сообщение: Re: arrays and functions in plpgsql