Re: [SQL] how can I query for unset timestamps

2005-02-22 Thread Bret Hughes
gt; HTH, > > Greg Williamson > DBA > GlobeXPlorer LLC > > -Original Message- > From: Bret Hughes [mailto:[EMAIL PROTECTED] > Sent: Tue 2/22/2005 1:09 PM > To: postgresql sql list > Cc: > Subject: [SQL] how can I query for unset timestamps > I

Re: [SQL] how can I query for unset timestamps

2005-02-22 Thread Gregory S. Williamson
: Subject:[SQL] how can I query for unset timestamps I have a table that I recently altered by adding several timestamp columns. I would like to query the table for those rows for which the timestamp has not been set but am unable to find a way to do so. any tips ? in psql the column appears

[SQL] how can I query for unset timestamps

2005-02-22 Thread Bret Hughes
I have a table that I recently altered by adding several timestamp columns. I would like to query the table for those rows for which the timestamp has not been set but am unable to find a way to do so. any tips ? in psql the column appears empty and char_length returns nothing. Some of what I h