compare two rows
От | Ben Kim |
---|---|
Тема | compare two rows |
Дата | |
Msg-id | 20101012201747.GA720@tamu.edu обсуждение исходный текст |
Ответ на | Re: default console user authentication? ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
Ответы |
Re: compare two rows
Re: compare two rows |
Список | pgsql-admin |
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(...)? Thanks. -- Ben Kim
В списке pgsql-admin по дате отправления: