|Subject||Re: [Firebird-Architect] Procedure parameters/variables and CHECKs|
> > Now that Domains have entered the domain (pun intended) ofI know, I've been checking them out, it's nice :-)
> > 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 canI'll register it as a feature request.
> register feature request in the tracker.
What I was interested in, is knowing if this would be much easier to
implement now that the CHECK of a Domain already works.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!