Frank Church wrote: > error: cannot cast tupe double precision to timestamp without time > zone > > What is the right syntax? It's not clear what the meaning of a double precision as a timestamp would be. How about you make that explicit: "timestamp" * interval '1 second' + timestamp '1900-01-01 00:00:00' or whatever you had in mind. -- Peter Eisentraut http://developer.postgresql.org/~petere/