Re: [GENERAL] IF ROW( NEW ) ROW( OLD )
On Wed, Jun 25, 2008 at 8:17 PM, Tom Lane [EMAIL PROTECTED] wrote: I think IF ROW(NEW.*) ROW(OLD.*) will work in recent releases. Actually you'd better use IF ROW(NEW.*) IS DISTINCT FROM ROW(OLD.*) ... you really don't want to rely on as it will not give the behavior you want in the presence of null columns. Thanks that worked! -- Regards, Richard Broersma Jr. Visit the Los Angles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] IF ROW( NEW ) ROW( OLD )
Is it possible to cast a table type to a ROW so that Row-Wise comparison can be achieved? -- Regards, Richard Broersma Jr. Visit the Los Angles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] IF ROW( NEW ) ROW( OLD )
On Wed, Jun 25, 2008 at 4:40 PM, Joshua D. Drake [EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] IF ROW( NEW ) ROW( OLD )
Richard Broersma [EMAIL PROTECTED] writes: 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. I think IF ROW(NEW.*) ROW(OLD.*) will work in recent releases. Actually you'd better use IF ROW(NEW.*) IS DISTINCT FROM ROW(OLD.*) ... you really don't want to rely on as it will not give the behavior you want in the presence of null columns. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general