postgresql info

DROP TYPE IF EXISTS info CASCADE;
CREATE TYPE info AS (state int4,operator varchar,time TIMESTAMP(0) );

array_append(info,ROW(1,\‘小米‘,CURRENT_TIMESTAMP(0))::info) 

ARRAY[ ROW(2,小米,CURRENT_TIMESTAMP(0))::info 

postgresql info

标签：