2015-01-31 2:40 GMT+01:00 Jim Nasby <jim.na...@bluetreble.com>: > On 1/25/15 2:03 AM, Pavel Stehule wrote: > >> It might not always be an integer, just happens to be so here. >> Should I try text instead? I don't have to have the case-insensitive >> matching. >> >> >> text can be better >> > > bytea would be even better yet, because that will always be a straight > binary comparison. text will worry about conversion and what not (though, > perhaps there's a way to force that to use C or SQL instead of something > like UTF8, short of changing the encoding of the whole database). >
true, good idea Regards Pavel > -- > Jim Nasby, Data Architect, Blue Treble Consulting > Data in Trouble? Get it in Treble! http://BlueTreble.com >
