14.02.2014 21:38, liviusliv...@poczta.onet.pl wrote: > i need to know what is difference in meaning of collate between this three > queries
Changing of collation is a kind of cast. Not recoverable. First and second query are ok because are grouped either by original value or by the same function. Third query is different: is grouped by function, but has original value in result set. Thus - error. Consider this: 1) select sin(x) ... group by x 2) select sin(x) ... group by sin(x) 3) select x ... group by sin(x) This way it is more clear, isn't it?.. -- WBR, SD. ------------------------------------------------------------------------------ Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
