Jeremy Drake wrote: > On Tue, 19 Sep 2006, Alvaro Herrera wrote: > >> Jeremy Drake wrote: >> >> > I have found the same thing with the type "timestamp without time >> zone". >> > The verbosity of type names seems rather extreme. >> >> Then use simply "timestamptz" (with TZ) or "timestamp" (without). > > Didn't know about these, learn something new every day I guess. I know > that double did not work due to the countless times I forget the > "precision" :)
then use float8. for a list of all the builtin aliases see http://www.postgresql.org/docs/current/static/datatype.html cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 1: 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