table types/check constraints - Mailing list pgsql-hackers

From Merlin Moncure
Subject table types/check constraints
Date
Msg-id b42b73150812120614q15e75672i7239e88948725b4e@mail.gmail.com
Whole thread Raw
List pgsql-hackers
In my gripe/suggestion here:
http://archives.postgresql.org/pgsql-hackers/2008-12/msg00642.php

I noted that it might be nice to handle check constraints over
composite types.  It turns out that table check constraints are not
enforced during casts:

postgres=# create table foo(f1 int, f2 int, check(f1 != f2));
postgres=# select (1,1)::foo; row
-------(1,1)
(1 row)

Should the be?  I've been thinking about how to marry tables and
composite types.

merlin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: default values for function parameters
Next
From: "David E. Wheeler"
Date:
Subject: Re: WIP: default values for function parameters