Received: from odysseus2.dohle.com (root@odysseus2.dohle.com [194.127.185.20]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA81553 for ; Fri, 2 Jun 2000 03:01:08 -0400 (EDT) (envelope-from vpaul@dohle.com) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus2.dohle.com (8.9.3/8.9.3) with SMTP id JAA25632 for ; Fri, 2 Jun 2000 09:01:07 +0200 Received: from wpaul.dohle.com by majestix.dohle.com id aa09289; 2 Jun 100 9:01 CETDST Received: by wpaul.dohle.com with Microsoft Mail id <01BFCC72.6AF96310@wpaul.dohle.com>; Fri, 2 Jun 2000 09:10:38 +0200 Message-ID: <01BFCC72.6AF96310@wpaul.dohle.com> From: Volker Paul To: "'pgsql-sql@postgresql.org'" Subject: RE: psql problem Date: Fri, 2 Jun 2000 09:10:36 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/14 Does anyone know why when I am in a particular DB as user postgres and use the following statement, why I get this error?" This is the statement; SELECT * FROM some_file where ID = 1; [Volker Paul] If your ID field is really uppercase, try: SELECT * FROM some_file where "ID" = 1; Cheers, Volker