...1-01'; COMPATIBILITY The SQL standard uses SELECT INTO to represent selecting values into scalar variables of a host program, rather than creating a new table. This indeed is th…...mple is INSERT INTO tab (domcol) VALUES ((SELECT domcol FROM tab WHERE false)); The empty scalar sub-SELECT will produce a null value that is considered to be of the domain type…...68.0.10'), ('192.168.1.43')); Tip For simple IN tests, it's better to rely on the list-of-scalars form of IN than to write a VALUES query as shown above. The list of scalars met…...o the range type name. Base Types The fourth form of CREATE TYPE creates a new base type (scalar type). To create a new base type, you must be a superuser. (This restriction is …...r the mawk implementation of awk arrays. Arrays in awk are associations of strings to awk scalar values. The mawk implementation stores the associations in hash tables. The hash…retrieve rows from a table or view NAME SELECT, TABLE, WITH - retrieve rows from a table or view SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT [ ALL | DISTINCT [ ON ( e…