Re: Proof of concept COLLATE support with patch

On Mon, Sep 05, 2005 at 01:52:45AM +0200, Petr Jelinek wrote:
> Tom Lane wrote:
> >
> >The hole in that argument is the assumption that there *is* a freely
> >available library that can be used (where freely == BSD license).
> >We wouldn't be having this discussion if we knew of one.
>
> I see this discussion as another reason to use ICU, I mean complete
> rewrite of locale handling to use ICU on all platforms. I know it's big
> project but it's doable for 8.2 and it would virtually solve all locale
> problems and could be base for new unicode/locale features. I am not
> sure if this is the way postgres wants to go tho (having dependency on
> such a big and uncommon library).

Maybe not so uncommon...

% ldd /usr/local/bin/php
/usr/local/bin/php:
...
-lresolv.1 => /usr/lib/libresolv.so.1
-lpq.4 => /usr/local/pgsql/lib/libpq.so.4
-lintl.0 => /usr/lib/libintl.so.0
-licudata.34 => /usr/local/lib/libicudata.so.34
-licuuc.34 => /usr/local/lib/libicuuc.so.34
-licui18n.34 => /usr/local/lib/libicui18n.so.34
-licuio.34 => /usr/local/lib/libicuio.so.34
...

Cheers,

Patrick