CREATE TABLE gcdeposit
(
gcdepositid serial NOT NULL,
datearray timestamp without time zone[],
deposittotalamount numeric,
entryid integer,
inserttime timestamp without time zone
);
插入新数据到 timestamp without time zone[]
INSERT INTO gcdeposit(
datearray, deposittotalamount, entryid, inserttime)VALUES ( '{"2014-5-6","2013-3-4"}', 5460.00, 1, now());