Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f17Dc5x50334 for ; Wed, 7 Feb 2001 08:38:05 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f16GUNx09184 for ; Tue, 6 Feb 2001 11:30:24 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f16G1ZH20707 for pgsql-sql@postgresql.org; Tue, 6 Feb 2001 11:01:35 -0500 (EST) (envelope-from news) From: Brice Ruth X-Newsgroups: comp.databases.postgresql.sql Subject: Re: SQL Join - MySQL/PostgreSQL difference? Date: Tue, 06 Feb 2001 10:01:35 -0600 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 43 Message-ID: <3A801FDE.E82A41B2@webprojkt.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org To: David Olbersen X-Mailer: Mozilla 4.76 (Macintosh; U; PPC) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200102/113 X-Sequence-Number: 1291 David, About the case-sensitivity, I was under the impression that PostgreSQL was case-insensitive unless things were explicitly put in quotes. This is at least what I read in the book ... -Brice David Olbersen wrote: > > On Thu, 1 Feb 2001, Brice Ruth wrote: > > ->SELECT > -> a.Number, > -> a.Code, > -> a.Text > ->FROM > -> b, > -> a > ->WHERE > -> (b.Id = a.Id) AND > > These next two statements are very ambiguous. Make them explicit as you have > with "(b.Id = a.Id)" and "(b.d_Id = 'key3')" > > Also, be sure that 'key3' is how what you want looks in the database > > -> (VersionId = 'key1') AND > -> (Category = 'key2') AND > -> (b.d_Id = 'key3') > ->ORDER BY > -> a.Number; > > Also, make sure ( '\d b' ) that your columns are case-sensatively named 'Id' and > such as this does matter. > > -- Dave -- Brice Ruth WebProjkt, Inc. VP, Director of Internet Technology http://www.webprojkt.com/