Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 40B1B475B05 for ; Tue, 27 Aug 2002 20:05:23 -0400 (EDT) Received: from pompom.freestart.hu (pompom.freestart.hu [213.197.64.6]) by postgresql.org (Postfix) with ESMTP id 7E1E9475AFC for ; Tue, 27 Aug 2002 20:05:22 -0400 (EDT) Received: from line-72-116.dial.freestart.hu ([213.197.72.116] helo=there) by freestart.hu with smtp (Freestart relay 1 (FS-Lin)) id 17jqKj-0008Ln-00; Wed, 28 Aug 2002 02:05:18 +0200 Content-Type: text/plain; charset="iso-8859-2" From: Papp Gyozo Reply-To: pgerzson@freestart.hu To: "Patrick Hatcher" , "Joseph L Montes" Subject: Re: Looking for help Date: Wed, 28 Aug 2002 02:06:14 +0200 X-Mailer: KMail [version 1.3.1] Cc: pgsql-php@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: X-Scanner: exiscan by Freestart X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/86 X-Sequence-Number: 1431 2002. augusztus 28. 01:05 dátummal Patrick Hatcher ezt írta: > Use quotes around the field and table names that are not all lower > case: > > Ex: > $result = pg_query($db," Select 'Field1',field2, 'fEild3' > From'TABLE1' "); > AFAIK, opstgres needs double quotes to handle objects' names literally -- as written: $result = pg_query($db,' Select "Field1",field2, "fiEld3" From "TABLE1"'); text within simple quotes represents string literals. -- Papp, Győző - pgerzson@freestart.hu