Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY

From: Boris Folgmann <boris(at)folgmann(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY
Date: 2012-07-30 09:56:35
Message-ID: jv5lok$1bmr$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message andervalbh 2012-07-30 13:15:37 BUG #6785: Memory Leak in plpgsql
Previous Message Emcisc (JinWei) Zhao 2012-07-30 03:49:55 Error on pg_settings.bytea_output for pg9.1