Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Recheck condition
- From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
- To: Josh Harrison <joshques(at)gmail(dot)com>
- Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Postgresql General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Recheck condition
- Date: Fri, 30 Nov 2007 09:55:42 -0300
Josh Harrison escribió: > Thanks... > I have 1 more question in the same line... > > *Query1* > SELECT person_id FROM person WHERE (column1=1 AND column2='62') > INTERSECT > SELECT person_id FROM person WHERE (column1=1 AND column2='189') Hmm, I think INTERSECT (and EXCEPT) is pretty stupid in Postgres in general. Maybe INTERSECT ALL could be a bit faster, because it can avoid the sort steps. Make sure you eliminate duplicates if they are a concern. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "[PostgreSQL] is a great group; in my opinion it is THE best open source development communities in existence anywhere." (Lamar Owen)
- Follow-Ups:
- Re: Recheck condition
- From: Josh Harrison
- Re: Recheck condition
- References:
- Re: Recheck condition
- From: Josh Harrison
- Re: Recheck condition
- From: Martijn van Oosterhout
- Re: Recheck condition
- From: Martijn van Oosterhout
- Re: Recheck condition
- From: Josh Harrison
- Re: Recheck condition
- From: Alvaro Herrera
- Re: Recheck condition
- From: Josh Harrison
- Re: Recheck condition
- Prev by Date: Re: Recheck condition
- Next by Date: Re: PostgresSQL vs Ingress
- Previous by thread: Re: Recheck condition
- Next by thread: Re: Recheck condition
- Indexes: