On 09/18/2012 07:32 AM, Tom Lane wrote:
It's easier to understand why this is if you realize that SQL has a very
clear model of a "pipeline" of query execution.
I just wish they hadn't written it backwards!
It'd be much less confusing were it formulated as something like:
SELECT
FROM thetable
WHERE first_letter > 'a'
RESULTS left(value,1) AS first_letter
or something, where the order is more obvious. I really dislike the way
SQL is written not-quite-backwards.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
