Subject 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

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?


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