On Tue, Jun 02, 2009 at 11:26:05AM -0500, Brandon Metcalf wrote: > Am I creating the table correctly? If so, how do I insert or update > rows?
timestamp[] is array of timestamps. there is no way to make timestamps "without subsecond data". you can add trigger to remove unneeded parts of the data, or (much better) strip it while selecting data - for example, using to_char() function. Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: [email protected] / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
