Sequential select queries...??

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

Responses

Browse pgsql-sql by date

  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?