method
SavepointSQL.array
values: any[],
Creates a new SQL array parameter
@param values
The values to create the array parameter from
@param typeNameOrTypeID
The type name or type ID to create the array parameter from, if omitted it will default to JSON
@returns
A new SQL array parameter
const array = sql.array([1, 2, 3], "INT");
await sql`CREATE TABLE users_posts (user_id INT, posts_id INT[])`;
await sql`INSERT INTO users_posts (user_id, posts_id) VALUES (${user.id}, ${array})`;Referenced types
type ArrayType =
| 'BOOLEAN'
| 'BYTEA'
| 'CHAR'
| 'NAME'
| 'TEXT'
| 'CHAR'
| 'VARCHAR'
| 'SMALLINT'
| 'INT2VECTOR'
| 'INTEGER'
| 'INT'
| 'BIGINT'
| 'REAL'
| 'DOUBLE PRECISION'
| 'NUMERIC'
| 'MONEY'
| 'OID'
| 'TID'
| 'XID'
| 'CID'
| 'JSON'
| 'JSONB'
| 'JSONPATH'
| 'XML'
| 'POINT'
| 'LSEG'
| 'PATH'
| 'BOX'
| 'POLYGON'
| 'LINE'
| 'CIRCLE'
| 'CIDR'
| 'MACADDR'
| 'INET'
| 'MACADDR8'
| 'DATE'
| 'TIME'
| 'TIMESTAMP'
| 'TIMESTAMPTZ'
| 'INTERVAL'
| 'TIMETZ'
| 'BIT'
| 'VARBIT'
| 'ACLITEM'
| 'PG_DATABASE'
| string & {}