Re: IF ROW( NEW ) <> ROW( OLD )

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: IF ROW( NEW ) <> ROW( OLD )
Дата
Msg-id 396486430806251947u6e0dcd5kc804edc5412e057f@mail.gmail.com
обсуждение исходный текст
Ответ на IF ROW( NEW ) <> ROW( OLD )  ("Richard Broersma" <richard.broersma@gmail.com>)
Ответы Re: IF ROW( NEW ) <> ROW( OLD )  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, Jun 25, 2008 at 4:40 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> I have never tried it but you may be able to do it with a composite
> type.

True.  However, I was under the impression that table types were
essentially composite types.  So I thought that composite types would
behave the same.

I could manually expand the composite type OLD and NEW to enumerate
each field and make a row wise comparison.  However, I was hoping to
avoid that.
--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: could not open relation with OID 2836
Следующее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: ERROR: could not open relation with OID 2836