SELECT * FROM unpack (
ON ville_tempdata
InputColumn ('packed_temp_data')
OutputColumns ('city', 'state', 'temp_f')
OutputDataTypes ('varchar', 'varchar', 'real')
Delimiter (',')
Regex ('(.*)')
RegexSet (1)
Exception ('true')
) ORDER BY sn;
Because comma is the default delimiter, the Delimiter argument in the preceding call is optional.