Re: COLLATE

Filip Rembiałkowski wrote:
> Greg Stark wrote:
>
>     But the closest partial solution suggested so far is the pg_xfrm (sic) 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.
>
>
> But I have no idea how to compile/install it.
>
> 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.)

What is the answer to Filip's question?  I didn't see an answer in the list archives.  I've seen several copies of Joe
Conway'spg_strxfrm.c code on the web, and it always refers to the Warn_restart variable, which doesn't seem to exist in
the8.1.4 code that I'm using. 

I am working with a database in UTF-8 encoding using "C" collation - but I'd occasionally like to ORDER BY columns
containingreal UTF-8 data.  

Would the pg_strxfrm() function get used in a new operator class function?   I'll read up on operator classes in
chapter32.14 of the docs, but if someone has a simple example, it might help other searchers of the archives. 

Thanks,
Kevin Murphy