through my patented unit testing technology (caffein and sleep deprivation) I came across this: db=> SELECT 1 FROM object WHERE object IS NOT NULL; ERROR: unrecognized node type: 302
where I was expecting something more like this: db=> SELECT 1 FROM object WHERE mispelt_column IS NOT NULL; ERROR: column "mispelt_column" does not exist Occurs when a valid table name is present in the WHERE clause where a column name would be expected. Present in 7.4beta5 (and also in 7.3.4 with the message "expression_tree_walker: Unexpected node type 711"). Ian Barwick [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: 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