Martijn Tonies escreveu:

> Hi,
>
> Now that Domains have entered the domain (pun intended) of
> PSQL, would it be possible to do things like:
>
> create procedure myproc1 (i int check (value between 1 and 10), .. )
> ...
> declare variable v_bool char(1) check (value in ('T', 'F') or value is
> NULL);
>
> I think this would enhance the current PSQL even more and allows for
> better checking of values inside procedural code.
>
> Does the current domain check implementation help to accomplish this?

Domain check constraints are enforced when domain is used directly
(without TYPE OF).

Inline checks are possible, but I don't think it's priority. You can
register feature request in the tracker.


Adriano