Re: [GENERAL] Aliasing syntax question

2009-02-19 Thread Tom Lane
Kevin Murphy writes: > Substitute the following pairs of values for X and Y in the query below, > and all of them work (in PG 8.3.6, at least): > X Y > gg > i g(i) > gg(i) > g.i g(i) > create or replace function unnest(anyarray) > returns setof anyelement as $$ > select $1[X] fro

[GENERAL] Aliasing syntax question

2009-02-19 Thread Kevin Murphy
I've now seen the 'unnest' function defined in a few different ways with regard to aliases. Substitute the following pairs of values for X and Y in the query below, and all of them work (in PG 8.3.6, at least): X Y gg i g(i) gg(i) g.i g(i) create or replace function unnest(any