Re: COLLATE

(group dupe)

05 Jun 2006 12:53:57 -0400, Greg Stark <gsstark(at)mit(dot)edu>:
>
> But the closest partial solution suggested so far is the pg_xfrm function that
> has been implemented and posted at least three times by three different
> posters to the postgres mailing lists. In the interest of avoiding a fourth
> independent implementation I'll attach the one I use below, it's not big.
>

Thanks! It may be the only solution available at the moment.

But I have no idea how to compile/install it.
I imagine there should be separate /contrib/pg_strxfrm directory, with
the makefile etc.
is it correct? if so, how should the makefile look like?

I tried compiling but it failed:

pgdba(at)sulaco:~/src/postgresql-8.1.3/src$ gcc -I ./include -fPIC -c pg_strxfrm.c
pg_strxfrm.c: In function 'pg_strxfrm':
pg_strxfrm.c:98: error: 'Warn_restart' undeclared (first use in this function)
pg_strxfrm.c:98: error: (Each undeclared identifier is reported only once
pg_strxfrm.c:98: error: for each function it appears in.)