*How can I get an AND search (people with Dark Hair AND who are President)?*
The two joins didn't work? Or were they too slow ? Best, Oliveiros 2008/12/10 Bryce Nesbitt <[EMAIL PROTECTED]> > > > Milan Oparnica wrote: > > This is how I do it, and it runs fast: > > select p.* > > from test_people p inner join test_attributes a on p.people_id = > > a.people_id > > where a."attribute" = @firstAttr or a."attribute" = @secondAttr > But that does an "or" search, not "and", returning Satan in addition to > Obama: > > select * from test_people p inner join test_attributes a on p.people_id > = a.people_id > lyell5-> where a."attribute" = 'Dark Hair' or a."attribute" = 'USA > President'; > +-----------+-------------+-----------+---------------+ > | people_id | person_name | people_id | attribute | > +-----------+-------------+-----------+---------------+ > | 8 | Obamba | 8 | USA President | > | 8 | Obamba | 8 | Dark Hair | > | 8 | Obamba | 8 | Dark Hair | > | 10 | Satan | 10 | Dark Hair | > +-----------+-------------+-----------+---------------+ > > How can I get an AND search (people with Dark Hair AND who are President)? > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
