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: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007