Re: [PHP-DB] MySQL Conditional Trigger
[email protected] (Chris)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Chris wrote: >>> unknown compared to anything is unknown. >>> >> he was talking about plsql and condition evaluation (ends with true or >> false), your point is absolutely useless. > > The context is in the database - my example is in the database. How is > that useless? In case you missed it, this is the context: > Which only works when ShipDate was not NULL to begin with. > I suppose it evaluates the following to FALSE > IF NULL != '2008-10-31' AND '2008-10-31' IS NOT NULL THEN > (not liking the "NULL != '2008-10-31'" part) > > Please give me the correct syntax. > TIA > > anything compared to NULL is always false ie - you are wrong. -- Postgresql & php tutorials http://www.designmagick.com/