Postgres Pro
Downloads
Home   >   mailing lists

Thread: create domain ... with check

create domain ... with check

From
"Merlin Moncure"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I looked on the to-do list and noticed adding check constraints to domains is not on it.<span
style="mso-spacerun:yes"> </span>IMO, being able to add a validation constraint is one of the very best things about
domains.<spanstyle="mso-spacerun:yes">  </span><span style="mso-spacerun:yes"> </span>Is anybody planning to work on
this?<spanstyle="mso-spacerun:yes">  </span></span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Regards,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Merlin</span></font></div>

Re: create domain ... with check

From
Rod Taylor
Date:
On Tue, 2003-07-22 at 09:06, Merlin Moncure wrote:
> I looked on the to-do list and noticed adding check constraints to
> domains is not on it. IMO, being able to add a validation constraint
> is one of the very best things about domains.   Is anybody planning to
> work on this?

7.4 has descent domain support, including check constraints, alter
domain, and a number of coercion fixes.