if !NULL ? - Mailing list pgsql-general

From Lev Lvovsky
Subject if !NULL ?
Date
Msg-id Pine.LNX.4.43.0205161625260.6216-100000@ground0.sonous.com
Whole thread Raw
Responses Re: if !NULL ?
List pgsql-general
ok, so more odd-ball questions

I have two columns in a table:

bool_bill | billing_id

one is a boolean that determines if we bill a customer, and the other one
is NULL if we don't, and has a billing_id of that customer if we do.  the
billing_id uses a foreign key on the billing table to check that the
billing_id exists.

what I'd like to do is if bool_bill = y, then there has to be something in
billing_id (automatically checked with the foreign key).

again, do I need a function for this?

thanks!!!

-lev




pgsql-general by date:

Previous
From: Vincent Stoessel
Date:
Subject: simple yet complex join
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: simple yet complex join