Select hardcoded values without table

Question

I need to run a select without actually connecting to any table. I just have a predefined hardcoded set of values I need to loop over:

foo bar fooBar 

And I want to loop through those values. I can do:

select 'foo', 'bar', 'fooBar'; 

But this returns it as one row:

 ?column? | ?column? | ?column?  ----------+----------+----------  foo      | bar      | fooBar (1 row) 

I am using Postgresql.

Answer 1

select a from (     values ('foo'), ('bar'), ('fooBar') ) s(a); 

http://www.postgresql.org/docs/current/static/queries-values.html

Answer 2

Using unnest()

expand an array to a set of rows

select unnest(array['foo', 'bar', 'fooBar']); 

demo