PostgreSQL timestamp deserialisation loses millisecond precision, when timestamp is contained in an array of composite types

[lukaseder]

Fetching from this function incurs in a loss of precision in the parsed timestamp:

CREATE OR REPLACE FUNCTION f5193(u OUT u_5193[])
AS $$
  SELECT ARRAY[
    ROW(1, timestamp '2000-01-02 03:04:05.067890'),
    ROW(2, timestamp '2000-02-02 02:02:02.222222')
  ]::u_5193[]
$$ LANGUAGE sql;
/

This is because internally, a SimpleDateFormat is used, without support for fractional seconds.

---

See: http://stackoverflow.com/q/36413530/521799