> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Stephen Russell > Sent: Monday, February 16, 2009 11:10 AM > To: [email protected] > Subject: Re: SQL Behavior > <snipped> > > You can get the wrong data when you don't lay out your group bys properly. > > It would be better if the compiler spanks you for doing it wrong. Oh > yes it is. But you want to override that because you know better??? > >
At my last gig for 3 years I worked in PostgreSQL pretty much exclusively and it enforced the Group By syntax... as painful as it was at times (being a lazy VFP developer of 16 years) I think the enforcement of the syntax is the way to go... that's why they created temp tables isn't it?? <g> Matt Jarvis Programmer/DBA King | Retail Solutions 541-349-8512 Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
