X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 29B77D6F17 for ; Sat, 10 Sep 2005 12:46:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32136-09 for ; Sat, 10 Sep 2005 15:46:20 +0000 (GMT) Received: from mailout03.sul.t-online.com (mailout03.sul.t-online.com [194.25.134.81]) by svr1.postgresql.org (Postfix) with ESMTP id 83E5CD6EA6 for ; Sat, 10 Sep 2005 12:46:17 -0300 (ADT) Received: from fwd34.aul.t-online.de by mailout03.sul.t-online.com with smtp id 1EE7YT-0002wC-08; Sat, 10 Sep 2005 17:46:13 +0200 Received: from pD9F8CAE4.dip.t-dialin.net (Xd7Y9OZJre8c91-usRIwymXovXCcYOXzqvtGNw3LFhogf+XddEbqcK@[217.248.202.228]) by fwd34.sul.t-online.de with esmtp id 1EE7YS-2B2O5A0; Sat, 10 Sep 2005 17:46:12 +0200 From: Michael Hoeller Reply-To: Michael Hoeller To: pgsql-sql@postgresql.org Subject: how to have 2 select creteria on one column? Date: Sat, 10 Sep 2005 17:45:50 +0200 User-Agent: KMail/1.7.1 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200509101745.50847.MichaelHoeller@t-online.de> X-ID: Xd7Y9OZJre8c91-usRIwymXovXCcYOXzqvtGNw3LFhogf+XddEbqcK X-TOI-MSGID: b639854f-47ec-4a87-8319-255073c9af56 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/106 X-Sequence-Number: 22653 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