Re: Convert to upper - Mailing list pgsql-general

On Fri, Mar 02, 2001 at 11:05:42AM -0500, Rod Taylor wrote:
> check
>
> create table uppercase (
>   name char(15) check (name ~ '[A-Z]')
> );

If don't want lowercase letters, but allow digits, !@#$%^&*( etc.:

create table uppercase (
  name char(15) check (name !~ '[[:lower:]]')
);

If you want only uppercase letters:

create table uppercase (
  name char(15) check (name ~ '^[[:upper:]]*$');
);

Tomek

--
.signature: Too many levels of symbolic links