2015-10-04 17:07 GMT+02:00 Pavel Stehule <pavel.steh...@gmail.com>: > > > 2015-10-04 16:37 GMT+02:00 Tom Lane <t...@sss.pgh.pa.us>: > >> Pavel Stehule <pavel.steh...@gmail.com> writes: >> > I am testing PostgreSQL (master) on Fedora 23. The query >> >> > ELECT p1.oid, p1.proname, p2.oid, p2.proname >> > FROM pg_proc AS p1, pg_proc AS p2 >> > WHERE p1.oid < p2.oid AND >> > p1.prosrc = p2.prosrc AND >> > p1.prolang = 12 AND p2.prolang = 12 AND >> > (p1.proisagg = false OR p2.proisagg = false) AND >> > (p1.prolang != p2.prolang OR >> > p1.proisagg != p2.proisagg OR >> > p1.prosecdef != p2.prosecdef OR >> > p1.proleakproof != p2.proleakproof OR >> > p1.proisstrict != p2.proisstrict OR >> > p1.proretset != p2.proretset OR >> > p1.provolatile != p2.provolatile OR >> > p1.pronargs != p2.pronargs); >> >> > fails on assert >> >> Works for me ... what locale/collation are you running in? >> > > LANG=cs_CZ.UTF-8 >
it depends on locale - it is working with C or en_US.UTF-8, but doesn't work with Czech locale Pavel > > Regards > > Pavel > > > >> >> regards, tom lane >> > >
