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 <[email protected]> > Jan Bakuwel <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
