Received: from federal.ecolo.be (mail.ecolo.be [193.121.149.100]) by postgresql.org (Postfix) with ESMTP id 81F6E475A69 for ; Wed, 24 Jul 2002 07:52:08 -0400 (EDT) Received: by FEDERAL with Internet Mail Service (5.5.2653.19) id ; Wed, 24 Jul 2002 13:52:43 +0200 Message-ID: <8126A160E6D1D1119AFF00A0CC5C8B0F01228E65@FEDERAL> From: ROUWEZ Stephane To: "'pgsql-sql@postgresql.org'" Subject: Problem with my query whithout double-quotes Date: Wed, 24 Jul 2002 13:52:40 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200207/379 X-Sequence-Number: 8757 Hi, My pgsql runs on WinNT Server 4. When I try to SELECT nom, prenom FROM individu WHERE numero=2 I have : ERROR: Relation "individu" does not exist It only works if I write : SELECT "Individu"."Nom","Individu"."Prenom" FROM "Individu" WHERE "Individu"."NumIndiv"=2 Can someone help me ? Thanks Stephane ------------------------------ http://www.ecolo.be