X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69C60542EF for ; Sat, 23 Apr 2005 15:31:08 -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 58565-02 for ; Sat, 23 Apr 2005 18:31:03 +0000 (GMT) Received: from tomts22-srv.bellnexxia.net (tomts22.bellnexxia.net [209.226.175.184]) by svr1.postgresql.org (Postfix) with ESMTP id 66356542CC for ; Sat, 23 Apr 2005 15:31:00 -0300 (ADT) Received: from acer.sympatico.ca ([65.95.128.185]) by tomts22-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with ESMTP id <20050423183058.NDDZ21470.tomts22-srv.bellnexxia.net@acer.sympatico.ca> for ; Sat, 23 Apr 2005 14:30:58 -0400 Message-Id: <5.2.1.1.0.20050423142822.04965cf0@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Sat, 23 Apr 2005 14:30:45 -0400 To: pgsql-sql@postgresql.org From: Frank Bax Subject: Re: weird SQL statement question In-Reply-To: <1057768D27BE@sagit-server.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.092 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/361 X-Sequence-Number: 21254 At 01:55 PM 4/23/05, Tadej Kanizar wrote: >Ok, so I installed the latest version of Postresql (8.02) on a WinXP SP2=20 >machine.. > >My question is why won't the statement SELECT * FROM table work, whereas=20 >the statement SELECT * FROM =BBtable=AB works! > >And, to explain a bit more, here's another example: > >INSERT INTO TestTable (Name, Surname) VALUES ('name', 'surname'); .. this= =20 >DOESN'T work > >INSERT INTO =BBTestTable=AB (=BBName=AB, =BBSurname=AB) VALUES ('name',= 'surname'); ..=20 >this DOES work If you create a table using quotes and mixed-case, you will need quotes=20 every time you reference the table. Don't use quotes when you create the=20 table and you won't need them when you acces the table with other commands.