Both works fine: SELECT generate_series AS id FROM generate_series(1,5);
and SELECT id FROM generate_series(1,5) AS foo(id); Technically dont know is there any differenece... Thanks, Misa 2012/5/15 Tom Lane <t...@sss.pgh.pa.us> > Jan Bakuwel <jan.baku...@greenpeace.org> writes: > > What I need is the ability to name the column in the view, ie. > > > create view v as select 1 as "id" from func(5); > > I think what you're looking for is the ability to re-alias a column name, > for example > > select id from func(5) as foo(id); > > regards, tom lane > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >