Re: [SQL] Problem with my query whithout double-quotes

Stephan Szabo wrote: > On Wed, 24 Jul 2002, ROUWEZ Stephane wrote: > > >>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".

Re: [SQL] Problem with my query whithout double-quotes

On Wed, 24 Jul 2002, ROUWEZ Stephane wrote: > 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" WHER

[SQL] Problem with my query whithout double-quotes

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 ? Th