Armin Diehl writes:
> of cause that works, but what if we need a case incensitive primary key, the
Then it's not really a primary key, isn't it?
> example ist very slow if you have a lot of records. Is that possible ?
You probably want to convert or check your data on input, depending on
your application. Alternatively you could try to implement your own data
type based on text but make the = operator case insensitive, but that will
probably create all sorts of extra trouble (indexes come to mind).
> > select * from userdata where lower(name) = 'john'
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/ Sweden
