Re: Help to simplify sample query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: email_daniel_h(at)yahoo(dot)com(dot)br
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help to simplify sample query
Date: 2004-03-09 06:27:33
Message-ID: 21339.1078813653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Daniel Henrique Alves Lima <email_daniel_h(at)yahoo(dot)com(dot)br> writes:
> I don't think this is possible, but: Is there a efficient way to
> compare if the result of a query is a superset of the result of another ?

Perhaps do "SELECT foo EXCEPT SELECT bar" and see if you get anything?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message BenLaKnet 2004-03-09 07:53:42 Re: designer tool connect to PostgreSQL
Previous Message Tomasz Myrta 2004-03-09 06:24:52 Re: Help to simplify sample query