Subject Re: [Firebird-Architect] Procedure parameters/variables and CHECKs
Author Martijn Tonies
> > 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).

I know, I've been checking them out, it's nice :-)

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

I'll register it as a feature request.

What I was interested in, is knowing if this would be much easier to
implement now that the CHECK of a Domain already works.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!