getting access to full precision timestamp (microseconds) in returned database value

[spollack]

postgres stores timestamps in microsecond precision. When a timestamp value comes back through node-postgres, it gets mapped to a javascript Date object with millisecond precision. I have a scenario now where i need to see the exact value. is there a way to do this?

Background:

• i have a trigger that sets the updated_at timestamp on any row update
• I'd like to use this for optimistic concurrency control across long operations, by checking if the row updated_at timestamp is still at the last value i read, or if someone else updated the row in the intervening time
  Alternatively, have folks solved this using version numbers instead of timestamps, or some other scheme? I want the version/timestamping to be database enforced, not client-code enforced, for robustness.

Thanks.

[spollack]

i'm going to move to version numbers instead. sorry for the noise.

[freewil]

You can override the parser for timestamp datatypes so it stays a string and isn't parsed into a Date object.

See #107 (comment)

[DaAwesomeP]

@freewil & @brianc, it seems that types.js has been removed. I can't even get milliseconds shown now. It also doesn't round; it only truncates it, which is not correct anyways.

[freewil]

@DaAwesomeP looks like @brianc has moved this out into another module, pg-types

[DaAwesomeP]

Thanks @freewil! That works perfectly.