On Tue, Oct 12, 2010 at 1:17 PM, Ben Kim <bkim@xxxxxxxx> wrote: > Admins, > > What is the best way to compare two rows from within psql cli client? > > It has ~30 fields, and the two rows are duplicate data but there might > be differences. > > id field1 field2 field3 ... > =========================== > id1 value1 value2 value3 ... > id2 value1 value2 value3 ... > > I could write a generic script to iterate through the list of fields and > compare each field values, or concatenate the fields to a string, but wondered what is out there. > > Also, is there a way around to use select row(...) = row(...)? Does: (T1.value1,T1.value2, T1.value3, ... ) IS NOT DISTINCT FROM (T2.value1,T2.value2, T2.value3,...) or: Row( T1.* ) IS NOT DISTINCT FROM ( T2.* ) work for you? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
