Re: Retrieve columntypes and checks?

I gmane.comp.db.postgresql.novice, skrev Jeff Eckermann:
>  If there is a small number of allowed values, a check
>  constraint may be most convenient.
>
>  Jesper, a full-featured RDBMS like PostgreSQL provides
>  lots of capability to validate your data in the
>  backend (including referential integrity, as Oliver
>  mentioned).  This protects your data against
>  programming mistakes, and frees your application
>  programmer to concentrate on the specifics of the
>  application.  You will gain by spending some time
>  reading about it.  Any good book on SQL will give you
>  an introduction.

You could argue that way, but when used in a perl/CGI script i really
think it's nice for the users to have some validation of data in
JavaScript instead of needing to reload the hole page just to validate
data.

Jesper

--
./Jesper Krogh, jesper@krogh.cc
Jabber ID: jesper@jabbernet.dk