Hi,
Your explanation is very good but i see that i was not clear in question.
I understand that collate is for sorting or upper but what is difference in
maining of collation in this three queries.
What do
Select field collate pxw_plk from ...
What do
.... Group by field collate pxw_plk
What difference if i remove collate?
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: "Dimitry Sibiryakov" <s...@ibphoenix.com>
Do: "For discussion among Firebird Developers"
<firebird-devel@lists.sourceforge.net>
Temat: [Firebird-devel] Fw: [firebird-support] Difference in "collation" meaning
Data: pt., lut 14, 2014 22:11
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
------------------------------------------------------------------------------
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
