From: | Mark Mikulec <mm98au(at)badger(dot)ac(dot)brocku(dot)ca> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Sequential select queries...?? |
Date: | 2001-08-15 00:40:50 |
Message-ID: | 3B79C512.9F6E09B7@badger.ac.brocku.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
At first I thought what I was trying to do was simple and could be done
easily - but alas, I've spent way too much time and could not figure out
how to get the results in question.
Let's say I have a table T comprised of id of type integer, name and
description both of type text.
What i'd like to do is the following:
Select id from T where name = 'bleh';
and
Select id from T where description = 'bleh';
and result both results in the same result set. That is, duplicate id's
if they appear. So then I could do a GROUP BY and a COUNT to see how
many appeared in only one, and how many appeared in both.
Could someone help me? I've tried countless different sql queries, can't
seem to get one to work. If I can just get those duplicate id's in the
query.. then I'd be laughing and then I can complete my task.
Thanks in advance,
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Paul McGarry | 2001-08-15 01:12:47 | Temp tables being written to disk. Avoidable? |
Previous Message | Josh Berkus | 2001-08-14 22:44:20 | Re: Deadlocks? What happened to MVCC? |