On Thu, Oct 19, 2006 at 10:36:29AM -0400, AgentM wrote: > Only if each message is contained in its own transaction since now() > is effectively a constant throughout a transaction. In this case, I > would choose a surrogate key since it is likely that the table will > be referenced.
See timeofday(). -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match