Re: compare two rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Kim <bkim(at)tamu(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: compare two rows
Date: 2010-10-12 21:11:17
Message-ID: 6900.1286917877@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ben Kim <bkim(at)tamu(dot)edu> writes:
> What is the best way to compare two rows from within psql cli client?

In 8.4 and up you can just compare the row values, eg
select x.* = y.*
if x and y are known to be of the same rowtype.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Broersma 2010-10-12 21:12:36 Re: compare two rows
Previous Message Ben Kim 2010-10-12 20:17:47 compare two rows