What is the best way to force character data to upper case

Поиск
Список
Период
Сортировка
От Dennis
Тема What is the best way to force character data to upper case
Дата
Msg-id 005001cce171$2ccae430$8660ac90$@kabonkulator.com
обсуждение исходный текст
Ответы Re: What is the best way to force character data to upper case  (Chris Travers <chris.travers@gmail.com>)
Re: What is the best way to force character data to upper case  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general

I am wondering what the best way is to force character data to a specific case, like upper case for example.   Is a trigger or rule the only option?  Would a check constraint be better or faster than using rules or triggers, knowing that a check constraint puts the onus back on the client code to ensure the data is in the correct case?

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Frankel
Дата:
Сообщение: Re: restart server on Lion
Следующее
От: Chris Travers
Дата:
Сообщение: Re: What is the best way to force character data to upper case