Re: Re: Convert to upper
От | Rod Taylor |
---|---|
Тема | Re: Re: Convert to upper |
Дата | |
Msg-id | 01bb01c0a332$a1c49080$6500000a@jester обсуждение исходный текст |
Ответ на | Convert to upper (Matthias Teege <matthias@mteege.de>) |
Ответы |
Re: Convert to upper
|
Список | pgsql-general |
check create table uppercase ( name char(15) check (name ~ '[A-Z]') ); -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. ----- Original Message ----- From: "Mitch Vincent" <mitch@venux.net> To: <pgsql-general@postgresql.org> Sent: Friday, March 02, 2001 10:52 AM Subject: [GENERAL] Re: Convert to upper > > is there any way to limit values to upper case strings? > > Somthing like: > > > > name char(15) DEFAULT (upper(name)) > > > > or must I use triggers? > > I'd say a trigger is your best bet. > > -Mitch > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-general по дате отправления: