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

#1

On Wed, 2005-03-09 at 21:21 -0500, Tom Lane wrote:

Quote:

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 (AT) primefactor (DOT) com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#2

Quote:

select 1 from tab having 1=1;

returns 2 rows

I'm curious whats in those two rows... {{1} {1}} ?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] We are not following the spec for HAVING without GROUP - 03-09-2005 , 11:22 PM

Re: [BUGS] We are not following the spec for HAVING without GROUP - 03-10-2005 , 06:36 PM