row expression support?

David_Wong

This syntax is a subquery within a SELECT.  How to translate it to Vertica?

select seg_id from ( values ('BBBBCXCSBCMC'), ('BBBBCXCSBCMB'), ('BBBBCXCSBCL0'), ('BBBBCXCSBCMD'), ('BBBBCXCSBCMH'), ('BBBBCXCSBCMG') ) as temp_segs (seg_id)

The values represent 6 row expressions.

David_Wong

This seems to be the answer:
 SELECT seg_id FROM ( select  'BBBBCXCSBCMC' UNION ALL select 'BBBBCXCSBCMB' UNION ALL select..etc....  ) as temp_segs (seg_id)