On Mon, 15 Oct 2001, Christopher Kings-Lynne wrote: > Hmmm. I don't know why date_part isn't working, but I now only use the > EXTRACT syntax for maximum SQL compatibility. ie. Do this instead: > > v_seed := EXTRACT (EPOCH FROM CURRENT_TIMESTAMP);
Unfortunatly that gives the same error. I think the problem is that the underlying code isn't liking the EPOCH timezone. Tom mentioned he had patches. Take care, Bill ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html