Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f17FB6x62211 for ; Wed, 7 Feb 2001 10:11:06 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f17FAm928161; Wed, 7 Feb 2001 10:10:48 -0500 (EST) To: Brice Ruth cc: David Olbersen , pgsql-sql@postgresql.org Subject: Re: SQL Join - MySQL/PostgreSQL difference? In-reply-to: <3A801FDE.E82A41B2@webprojkt.com> References: <3A801FDE.E82A41B2@webprojkt.com> Comments: In-reply-to Brice Ruth message dated "Tue, 06 Feb 2001 10:01:35 -0600" Date: Wed, 07 Feb 2001 10:10:48 -0500 Message-ID: <28158.981558648@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/120 X-Sequence-Number: 1300 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