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

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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Ha

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

rows. A plain "select 1 from tab" returns zero rows when tab is empty. -- Mark Shewmaker [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]