Re: Easiest way to compare the results of two queries row by row and column by column

From: anupping <anupping(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Easiest way to compare the results of two queries row by row and column by column
Date: 2019-05-02 09:01:31
Message-ID: 1556787691679-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select * from (select id, my_age, ur_age as urage from datatable where
agegp != 'S') m where m.myage <> m.urage

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guntry Vinod 2019-05-02 12:20:10 Back Slash \ issue
Previous Message Pavel Stehule 2019-05-02 08:00:12 Re: Migrating an application with Oracle temporary tables