On Sat, Sep 10, 2005 at 17:45:50 +0200, Michael Hoeller <[EMAIL PROTECTED]> 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]' ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
