"Matt" <[EMAIL PROTECTED]> writes:
> insert into table (column) values (nullif('',''));
> ERROR: column "column" is of type boolean but
> expression is of type text.
Seems reasonable to me. What type would you expect '' to be?
> It works in MSSQL.
If you think silent conversions from text to boolean are a good idea,
use MSSQL. (Or create a cast to make PG do it ... but implicit
conversions across datatype categories are generally a bad idea in
my experience. They tend to fire in cases where you didn't expect it.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
