Feature Requests item #2792535, was opened at 2009-05-16 02:54 Message generated for change (Settings changed) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2792535&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL - general Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) >Summary: SQL: implement greatest / least Initial Comment: For some reason this doesn't work: sql>select GREATEST(5,3); !SELECT: no such binary operator 'greatest(tinyint,tinyint)' I didn't see GREATEST or LEAST in SQL92, but for some reason it seems to be defined in MonetDB anyway. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-07-09 21:33 Message: max/min operate on aggregated results. Greatest/Least results into a value choosen from two (or more) columns. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-07-09 20:54 Message: MAX/MIN don't work by chance? where do GREATEST/LEAST come from? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2792535&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
