constraint question - Mailing list pgsql-novice

From mwaples@optusnet.com.au
Subject constraint question
Date
Msg-id 3A4FA146.AA4FED3D@optusnet.com.au
Whole thread Raw
In response to RE: error "11"  ("Rob Arnold" <rob@cabrion.com>)
Responses Re: constraint question
Re: constraint question
Re: constraint question
List pgsql-novice
I have table users with a varchar field user_name,
Id like to restrict this to just alphanumeric characters
can I do this with a check constraint ?
or do I need to use a tigger and function ?

I've read the docs but can't seem to get it right - Im sure its fairly
simple and Id like to use it on a number of fields in a number of tables

pgsql-novice by date:

Previous
From: "Albert REINER"
Date:
Subject: Re: Re: how to get trigger start function not procedure
Next
From: "D. Duccini"
Date:
Subject: Re: constraint question