GS_LOGICAL_SET
GS_LOGICAL_SET records metadata defined by the SET data type.
| Column | Type | Description |
|---|---|---|
| setid | oid | Row identifier. |
| settypid | oid | OID of the SET data type |
| setnum | tinyint | Number of members of the SET data type. A maximum of 64 members are supported. |
| setsortorder | tinyint | Sorting order of members when the SET data type is defined. The value starts from 0. |
| setlabel | text | Member name of the SET data type. |
| dbnode | oid | Database OID. |
| originid | integer | Source identifier of a tuple. |
| createtime | timestamp with time zone | Timestamp when a tuple is inserted. |
| csnmin | bigint | CSN when a tuple is inserted. |
| csnmax | bigint | CSN when a tuple is updated or deleted. |
| numbers | integer | Number of members of the M-compatible SET and ENUM data types. This column is used only in M-compatible databases. |
| sortorder | integer | Sorting order of members when the M-compatible SET and ENUM data types are defined. This column is used only in M-compatible databases. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.