Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY - Mailing list pgsql-bugs

From Boris Folgmann
Subject Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY
Date
Msg-id jv5lok$1bmr$1@news.hub.org
Whole thread Raw
In response to Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY
List pgsql-bugs
Hi,

hubert depesz lubaczewski schrieb/wrote:
> generally - order by datname is understood as "order by *variable
> datname*". - which is null.

It's clear that it's a shadowing problem. But it's not a "FOR IN EXECUTE"
where a variable makes sense. I mean why is a "ORDER BY variable" valid in
"FOR IN"? In SQL you can't use ORDER BY NULL. If the order by clause is not
correct the whole statement should raise an error.

Tnx,
       Boris

pgsql-bugs by date:

Previous
From: andervalbh@gmail.com
Date:
Subject: BUG #6785: Memory Leak in plpgsql
Next
From: "Emcisc (JinWei) Zhao"
Date:
Subject: Error on pg_settings.bytea_output for pg9.1