Re: Curious sorting puzzle

[Ivan Voras <ivoras(at)fer(dot)hr>]

Tom Lane wrote:

> > An ideal solution would be to have a 
> > "not-locale-affected-varchar" field type :)
>
>
> If you're just storing ASCII then I think bytea might work for this.
> Do you need any actual text operations (like concatenation), or this
> just a store-and-retrieve field?

I've just tested bytea and it looks like a perfect solution - it supports:

- character-like syntax
- indexes
- uses indexes with LIKE 'x%' queries
- SUBSTRING()

That's good enough for us - it seems it's just what we need - a 
string-like type with byte collation.

Thanks!