row expression support?

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.


  • 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)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file