On Tue, May 29, 2001 at 03:16:34PM +0530, Binand Raj S. wrote:
>>>>>> "Penguin" == Penguin <[EMAIL PROTECTED]> writes:
>
> IF NEW.salary ISNULL THEN
> RAISE EXCEPTION ''% cannot have NULL salary'', NEW.empname;
> END IF;
>
>Ages since I worked with postgres, but...
>
>needn't that be a numerical comparison? Your salary is an int4, not
>text or varchar or whatever...
Binand. That is not my creation. It is directly copy, paste
from postgresql manual :-)
ISNULL is a special constant.
Warm Regards
Rajesh
>
>Binand
>
>
>
>--__--__--
--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA
Email ID : [EMAIL PROTECTED], [EMAIL PROTECTED]
Web Site : http://www.dempos.com
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/linux-india-help
