Re: [BUGS] We are not following the spec for HAVING without GROUP

Поиск
Список
Период
Сортировка
От Mark Shewmaker
Тема Re: [BUGS] We are not following the spec for HAVING without GROUP
Дата
Msg-id 1110432006.12946.2.camel@k9
обсуждение исходный текст
Ответ на We are not following the spec for HAVING without GROUP BY  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] We are not following the spec for HAVING without GROUP
Список pgsql-hackers
On Wed, 2005-03-09 at 21:21 -0500, Tom Lane wrote: 
> Comments?  Can anyone confirm whether DB2 or other databases allow
> ungrouped column references with HAVING?

In Sybase:
   1> select 2 as id, max(myfield) from mytable where 2=1   2> go    id    ----------- ----------              2 NULL
   (1 row affected)   1> select 2 as id, max(myfield) from mytable having 2=1   2> go    id    ----------- ----------
   (0 rows affected)

-- 
Mark Shewmaker
mark@primefactor.com



В списке pgsql-hackers по дате отправления: