[EMAIL PROTECTED] (Bob Smith, Hammett & Edison, Inc.) writes: > On a related note, does anyone know if 'current' works with DATE?
DATE does not have an internal representation of 'current', so the DATE input parser treats it the same as 'now'. AFAIR only timestamp (nee datetime) has that concept. FYI, the concept of 'current' has been deemed broken and removed altogether for 7.2. See discussions in the pgsql-hackers archives if you want to know why. regards, tom lane ---------------------------(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