[SQL] query using a date field that isn't set

2004-11-07 Thread John B. Scalia
Hi all,   I’ve got a SQL problem that’s stumping me. I have an employee table with a field labeled:   Emp_terminated    DATE   Obviously, some employees in this table won’t have this field set. I want a query to select only employees without this field being set, ie., only cur

[SQL] Bug in psql - Postgresql 7.3.1?

2003-10-03 Thread John B. Scalia
All,   I’m not certain if what I’m trying to do is legal, but if I execute a statement like:   UPDATE my_table SET field1=’new_value’ AND SET field2=’different_value’ WHERE my_table_id = ‘key’;   in psql, it reports that it has successfully updated one record. However, the record does