From: | zab08 <zab08(at)126(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: select problem |
Date: | 2010-11-02 02:36:57 |
Message-ID: | 5b70bac3.3dd0.12c0a71c8d6.Coremail.zab08@126.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
(SELECT * from mydata,city WHERE mydata.sample = 1 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
INTERSECT
(SELECT * from mydata,city WHERE mydata.sample = 2 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
EXCEPT
(
(SELECT * from mydata,city WHERE mydata.sample = 2 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
INTERSECT
(SELECT * from mydata,city WHERE mydata.sample = 3 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
)
UNION
(SELECT * from mydata,city WHERE mydata.sample = 1 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
INTERSECT
(SELECT * from mydata,city WHERE mydata.sample = 3 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
EXCEPT
(
(SELECT * from mydata,city WHERE mydata.sample = 2 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
INTERSECT
(SELECT * from mydata,city WHERE mydata.sample = 3 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
)
ps:
Here is set 1, 2, 3.
our target: (set 1 INTERSECT set 2) EXCEPT (set 2 INTERSECT set 3) UNION (set 1 INTERSECT set 3) EXCEPT (set 2 INTERSECT set 3).
your data is not correct.
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Schwarzer | 2010-11-02 06:54:47 | Re: Problem with Crosstab (Concatenate Problem) |
Previous Message | Scott Marlowe | 2010-11-02 01:56:44 | Re: Replication |