How to write null value to datetime array in PostgreSQL 8.3?

Question

I try to execute query:

INSERT INTO table_name
(
  timedate_array_field
)
VALUES
(
  '{NULL, NULL}'
)

But I get error "Could not convert string to DateTime: 'null'".

Answer 1

Just add single quotes for the value:

INSERT INTO table_name (timedate_array_field)
VALUES ('{NULL, NULL}')

-> SQLfiddle

BTW, the data type is not called "DateTime" or "timedate" in Postgres, but timestamp.