How do I do this queyr? - Mailing list pgsql-sql

From pierre@desertmoon.com
Subject How do I do this queyr?
Date
Msg-id 19990225204143.16870.qmail@desertmoon.com
Whole thread Raw
List pgsql-sql
All,
  Given a table of keywords. How would  I grab the distinct id's that have
  both keywords attached to it. Example:

  ID  | Keyword
  -------------
  1   | abc
  2   | abc
  3   | def
  1   | def

  We want all the id's that have BOTH abc AND def as keywords. I think I may
  be having a brain freeze here...it seems obvious but I just can't seem
  to get my brain to spit up the answer. :( Too much caffiene?

  Thanks for the help!

  -=pierre

pgsql-sql by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: SQL92 standard conformance [was Re: [SQL] OUTER JOINS in 6.4.2?? Work around??
Next
From: budin
Date:
Subject: ...