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

From Bruno Wolff III
Subject Re: how to have 2 select creteria on one column?
Date
Msg-id 20050910175733.GA11142@wolff.to
Whole thread Raw
In response to how to have 2 select creteria on one column?  (Michael Hoeller <MichaelHoeller@t-online.de>)
List pgsql-sql
On Sat, Sep 10, 2005 at 17:45:50 +0200, Michael Hoeller <MichaelHoeller@t-online.de> wrote:
> 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.

Your description isn't as precise as would be nice. But from what I can figure
you want:
code ~ '^k[^V]'


pgsql-sql by date:

Previous
From: MichaelHoeller@t-online.de
Date:
Subject: Re: how to update with a join?
Next
From: Bruno Wolff III
Date:
Subject: Re: how to update with a join?