Postgres Pro
Downloads
Home   >   mailing lists

Re: compare two rows - Mailing list pgsql-admin

From Tom Lane
Subject Re: compare two rows
Date
Msg-id 6900.1286917877@sss.pgh.pa.us
Whole thread Raw
In response to compare two rows  (Ben Kim <bkim@tamu.edu>)
List pgsql-admin
Tree view 
Ben Kim <bkim@tamu.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

pgsql-admin by date:

Previous
From: Ben Kim
Date:
Subject: compare two rows
Next
From: Richard Broersma
Date:
Subject: Re: compare two rows