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 по дате отправления: