upgrading to postgresql 8

Поиск
Список
Период
Сортировка
От guegue
Тема upgrading to postgresql 8
Дата
Msg-id e1d1c691050128132849e8dbbc@mail.gmail.com
обсуждение исходный текст
Ответы Re: upgrading to postgresql 8  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
when i upgraded from 7.4 to 8 many of my functions no loger worked,
they all had something in common:
DECLARE
  produto  RECORD;
BEGIN
  FOR producto IN SELECT producto FROM p LOOP

the error reported was: record "producto" is not assigned yet

i finally realized that name of the variable can no longer be the same
as the name of a column in the select statement.

i guess i will just have to re-write all my functions or is there way
around this?

javier

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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Moving from Sybase to Postgres - Stored Procedures
Следующее
От: Shawn Harrison
Дата:
Сообщение: Allowing update of column only from trigger