Element Literal Value

The diagram for Literal Collection refers to this section. Elements of a collection can be literal values for the following data types.
For a Collection of Type Literal Value Syntax
BOOLEAN t or f, representing TRUE or FALSE as a quoted string
CHAR, VARCHAR, NCHAR, NVARCHAR, CHARACTER VARYING, LVARCHAR, DATE Quoted String
DATETIME Literal DATETIME
DECIMAL, MONEY, FLOAT, INTEGER, INT8, SMALLFLOAT, SMALLINT Literal Number
INTERVAL Literal INTERVAL
Opaque data types Quoted String. The string literal must be recognized by the input support function for the associated opaque type.
Row Type Literal Row. When the collection element type is a named ROW type, you do not need to cast the inserted values to the named ROW type.
Important: You cannot specify the simple-large-object data types (BYTE and TEXT) as the element type for a collection.

Quoted strings must be specified with a different type of quotation mark than the quotation marks that encompass the collection, so that the database server can parse the quoted strings. Thus, if you use double ( " ) quotation marks to specify the collection, use single ( ' ) quotation marks to specify individual, quoted-string elements. (In databases where delimited identifiers are enabled, however, double quotation marks are not valid, except to delimit SQL identifiers.)