From: Ian Harding <iharding@pakrat.com>
To: pgsql-general@postgresql.org.pgsql-sql
Subject: Re: SQL Join - MySQL/PostgreSQL difference?
Date: Thu, 01 Feb 2001 20:45:00 -0800
Message-ID: <3A7A3B4C.856EC9EF@pakrat.com> (raw)
References: <3A79E9E8.238F653B@webprojkt.com>
Brice Ruth wrote:
> Greetings.
>
> I'm working with a product provided by a third part that interfaces to
> data housed in a database of your choice. Previously, my choice was
> MySQL - apparently it handled certain queries too slowly, so I'm giving
> PostgreSQL a shot. Here's the query:
>
> SELECT
> a.Number,
> a.Code,
> a.Text
> FROM
> b,
> a
> WHERE
> (b.Id = a.Id) AND
> (VersionId = 'key1') AND
> (Category = 'key2') AND
> (b.d_Id = 'key3')
> ORDER BY
> a.Number;
>
> (my apologies: I had to 'mangle' the table/column names because of NDA)
>
> So my question is this: would this query operate differently in MySQL
> than in PostgreSQL? The reason I ask is that this query in MySQL
> returns results, yet in PostgreSQL it does not. I read a post about
> PostgreSQL not supporting outer joins, but I don't have enough
> experience with SQL to determine if this is such a query or not. Please
>
> advise.
>
> Any help will be (as always) sincerely appreciated.
>
> --
> Brice Ruth
> WebProjkt, Inc.
> VP, Director of Internet Technology
> http://www.webprojkt.com/
It should work the same in both. The only thing I notice is that not all
the field names are qualified with table names or aliases. That can lead
to ambiguity, but the query would blow up on both databases if that were a
problem.
Ian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: iharding@pakrat.com, pgsql-general@postgresql.org.pgsql-sql
Subject: Re: SQL Join - MySQL/PostgreSQL difference?
In-Reply-To: <3A7A3B4C.856EC9EF@pakrat.com>
References: <3A79E9E8.238F653B@webprojkt.com> <3A7A3B4C.856EC9EF@pakrat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox