Re: WIP: default values for function parameters

2008/12/10 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
>> 2008/12/10 Bruce Momjian <bruce(at)momjian(dot)us>:
>>> Well, that is interesting, but in SQL we already use 'AS' in most places
>>> where we want to assign a label to a value, so it seems AS is more
>>> logical for SQL at this point.
>
>> Question is - what is label - is it parameter name or some other value?
>
>> Every output in SQL has default label - column name, or some default.
>> And we use "AS" for change this default label. So using AS for param
>> names is bad idea.
>
> That argument is complete nonsense. A function parameter can't possibly
> be an "output" of a SQL statement, so there is no conflict.
>

we speaking about two things probably. I speaking so using AS in two
independent meaning is wrong.

look again
select c as foo from tab ...
select fce(c as foo) from tab ...

when you use AS as param names specification, you change meaning of
some construct via used context?

is it true or false?

regards
Pavel Stehule

> regards, tom lane
>