From: | Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Using the query INTERSECTion |
Date: | 2007-06-18 14:10:41 |
Message-ID: | 200706181610.41688.vincenzo.romano@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everyone.
In order to build some dynamic queries (EXECUTE under PL/PgSQL)
I'm taking in consideration to use the INTERSECT operator in order
to split a WHERE-condition in a static one and a dynamic one to be
built at runtime.
Instead of
SELECT * FROM joinedtables WHERE static_cond AND dynamic_cond;
I could use:
SELECT * FROM joinedtables WHERE static_cond
INTERSECT
SELECT * FROM joinedtables WHERE dynamic_cond
I'm wondering what'd be the difference in efficiency between these
two queries.
Is there any advise?
Many thanks in advance.
--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2007-06-18 14:12:59 | Re: Command line export or copy utility? |
Previous Message | A. Kretschmer | 2007-06-18 13:40:55 | Re: Loop through all views with PHP |