We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


row expression support? — Vertica Forum

row expression support?

David_WongDavid_Wong
in General Discussion
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.

Comments

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...