Received: from morpheus.webprojkt.com (morpheus.webprojkt.com [209.61.155.148]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f17FDpx62408 for ; Wed, 7 Feb 2001 10:13:51 -0500 (EST) (envelope-from brice@webprojkt.com) Received: (qmail 29765 invoked by uid 604); 7 Feb 2001 15:13:46 -0000 Received: from unknown (HELO webprojkt.com) (216.170.131.123) by morpheus.webprojkt.com with SMTP; 7 Feb 2001 15:13:46 -0000 Message-ID: <3A81662A.DAAEEAA2@webprojkt.com> Date: Wed, 07 Feb 2001 09:13:45 -0600 From: Brice Ruth X-Mailer: Mozilla 4.76 (Macintosh; U; PPC) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: David Olbersen , pgsql-sql@postgresql.org Subject: Re: SQL Join - MySQL/PostgreSQL difference? References: <3A801FDE.E82A41B2@webprojkt.com> <28158.981558648@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/121 X-Sequence-Number: 1301 That was my understanding as well, thank you for the clarification. :) Tom Lane wrote: > > Brice Ruth writes: > > About the case-sensitivity, I was under the impression that PostgreSQL > > was case-insensitive unless things were explicitly put in quotes. > > Names in queries (of tables, fields, functions, etc) are > case-insensitive. This has nothing to do with the behavior of data > comparisons, however. > > regards, tom lane -- Brice Ruth WebProjkt, Inc. VP, Director of Internet Technology http://www.webprojkt.com/