Re: help with pagila - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: help with pagila
Date
Msg-id 20060901174040.GF17178@phlogiston.dyndns.org
Whole thread Raw
In response to Re: help with pagila  ("Walter Cruz" <walter.php@gmail.com>)
Responses Re: help with pagila  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Fri, Sep 01, 2006 at 02:26:39PM -0300, Walter Cruz wrote:
> So I can assume that the MySQL implementation is strange? (It accepts that
> kind of query)

In my experience, it is almost never safe to assume that the MySQL
approach to SQL bears anything but a passing resemblance to SQL
proper.  This is considerably better under recent releases, however,
and I think you'd find, if you used the strict mode in the most
recent release, that MySQL would choke on a query like you posted as
well.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.    --Philip Greenspun


pgsql-sql by date:

Previous
From: "Walter Cruz"
Date:
Subject: Re: help with pagila
Next
From: Tomas Vondra
Date:
Subject: Re: help with pagila