ouyangwulin created FLINK-38278:
-----------------------------------

             Summary: PostgresSQL supported array  field types.
                 Key: FLINK-38278
                 URL: https://issues.apache.org/jira/browse/FLINK-38278
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
    Affects Versions: cdc-3.5.0
            Reporter: ouyangwulin


CREATE TABLE array_types (
id SERIAL PRIMARY KEY,
text_a1 TEXT[],
int_a1 INTEGER[]
);

ALTER TABLE inventory.array_types
REPLICA IDENTITY FULL;

INSERT INTO array_types (id,text_a1, int_a1, matrix)
VALUES
(1,
ARRAY['electronics', 'gadget', 'sale'],
'\{85, 90, 78}'
);
 
suported array sql



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to