Re: [GENERAL] AS s(a) vs. AS a

2012-10-11 Thread Tom Lane
Thalis Kalfigkopoulos writes: > I see in the docs the following: > SELECT current_date + s.a AS dates FROM generate_series(0,14,7) AS s(a); > Trying it as: > SELECT current_date + a AS dates FROM generate_series(0,14,7) AS a; > yields exactly the same result. > Does the finer granularity/expres

[GENERAL] AS s(a) vs. AS a

2012-10-11 Thread Thalis Kalfigkopoulos
Hi all. I see in the docs the following: SELECT current_date + s.a AS dates FROM generate_series(0,14,7) AS s(a); Trying it as: SELECT current_date + a AS dates FROM generate_series(0,14,7) AS a; yields exactly the same result. Does the finer granularity/expressiveness offer some extra function