How to make a temporary table with the same data?

Question

PostgreSQL

Let's say there is this:
SELECT 'Economy';
produces:
?column?
----------
Economy
(1 row)
I would like to have not one row, but several, according to my desire. And yes, without creating an intermediate table.

Answer 1

small note #3: what the hell do you need a cross join for?
SELECT 'Economy' FROM generate_series(1,10);

Answer 2

A small side note to DevMan 's answer :

SELECT
  cols.*
FROM 
  (SELECT 'Economy'::character varying (25)  economy) AS cols
CROSS JOIN
  generate_series(1,10);

I changed SELECT 'Economy'::character varying (25) economyto not have ?column? , well, I set the explicit type.