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(at)krogh(dot)cc
Jabber ID: jesper(at)jabbernet(dot)dk