Re: Debugging postmaster to fix possible bug in Postgres? Followup
От | Dmitry Tkach |
---|---|
Тема | Re: Debugging postmaster to fix possible bug in Postgres? Followup |
Дата | |
Msg-id | 3E4C212E.2080805@openratings.com обсуждение исходный текст |
Ответ на | Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select (Manfred Koizar <mkoi-pg@aon.at>) |
Ответы |
Re: Debugging postmaster to fix possible bug in Postgres? Followup
Re: Debugging postmaster to fix possible bug in Postgres? Followup |
Список | pgsql-sql |
> > SQL92 says: > <direct select statement: multiple rows> ::= > <query expression> [ <order by clause> ] > [...] > 3) Let T be the table specified by the <query expression>. > > 4) If ORDER BY is specified, then each <sort specification> in the > <order by clause> shall identify a column of T. > Then it looks like postgres behaviour is still not compliant, if I read it correctly, because select x from mytable order by y; should be invalid according to this, but works just fine in postres. Dima. P.S. I think, this is a great feature actually (missed it a lot in informix), so, I hope, you guys won't start discussinghow to fix it :-)
В списке pgsql-sql по дате отправления: