Postgres Pro
Downloads
Home   >   mailing lists

how to have 2 select creteria on one column? - Mailing list pgsql-sql

From Michael Hoeller
Subject how to have 2 select creteria on one column?
Date
Msg-id 200509101745.50847.MichaelHoeller@t-online.de
Whole thread Raw
Responses Re: how to have 2 select creteria on one column?
Re: how to have 2 select creteria on one column?
List pgsql-sql
Tree view 
Hello, 

I would like to select every row which has got in the column CODE a "k" 
but I want to exclude every "kV" -- may be it is due to the fact that 
it is Saturday and I work too long I don't get it.. I tried a 
subselect, union but I struggle with the two select creteria on one 
column.

Can some one help me -- hope this is not a too stupid question. Normally 
google is my friend but also there I did not find a solution.

Thanks a lot 
Michael

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT: retrieve only 2 rows next to known row
Next
From: Richard Huxton
Date:
Subject: Re: how to have 2 select creteria on one column?