Re: IF ROW( NEW ) <> ROW( OLD ) - Mailing list pgsql-general

From Richard Broersma
Subject Re: IF ROW( NEW ) <> ROW( OLD )
Date
Msg-id 396486430806251947u6e0dcd5kc804edc5412e057f@mail.gmail.com
Whole thread Raw
In response to IF ROW( NEW ) <> ROW( OLD )  ("Richard Broersma" <richard.broersma@gmail.com>)
Responses Re: IF ROW( NEW ) <> ROW( OLD )  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: could not open relation with OID 2836
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: ERROR: could not open relation with OID 2836