Re: Insert triggers, is this a bug, is there a work around? - CHECK

Jonathan Leffler wrote: <big snip> > > Maybe that is more an issue of CHECK constraints need to be made > more sophisticated. Has anybody checked whether you can execute a > stored procedure in a CHECK clause? I suspect not, but you should > be able to do so. > <snip> > > Yours, > Jonathan Leffler (j.leffler@acm.org) #include <JustMyOpinion.h> > It's interesting to note that SQL92 defines all the constraints in terms of CHECKs. Informix (and others I think) hobble their CHECKs to exclude SELECT. The manual explicitly forbids stored procedure calls in CHECK constraints. Maybe one day we'll get a database that implements SQL92. I do understand that it would be a nightmare to optimize queries though. But triggers are worse... -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/