Feature Requests item #1769551, was opened at 2007-08-07 19:24 Message generated for change (Comment added) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1769551&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: Closed Priority: 5 Private: No Submitted By: Colin Foss (cgfoss) >Assigned to: Niels Nes (nielsnes) Summary: support coalesce within where clause Initial Comment: Support cast(coalesce(aaa,bbb)) within where clause of PSM. e.g. AND cast(coalesce(et.time, '00:00') as varchar(13)) == 'something' Currently an error is thrown: ERROR = !CASE: currently not supported here ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2008-01-02 19:40 Message: Logged In: YES user_id=490798 Originator: NO closed upon request ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2008-01-02 18:38 Message: Logged In: YES user_id=1498628 Originator: NO This feature is already implemented (in the last check ins) and its basic functionality is covered by the test: sql/src/test/coalesce.sql Regards, Romulo Note: My user rights do not allow me to close this feature request, so I ask to someone else to do it. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1769551&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
