Re: proposal sql: labeled function params

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: proposal sql: labeled function params
Дата
Msg-id
23099.1219593601@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Peter Eisentraut <peter_e@gmx.net>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params Decibel! <decibel@decibel.org>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Gregory Stark <stark@enterprisedb.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params Bruce Momjian <bruce@momjian.us>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Robert Haas" <robertmhaas@gmail.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Decibel! <decibel@decibel.org>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Martijn van Oosterhout <kleptog@svana.org>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Teodor Sigaev <teodor@sigaev.ru>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: Feeding results back into select (was: proposal sql: labeled function params) "D'Arcy J.M. Cain" <darcy@druid.net>
Re: Feeding results back into select Teodor Sigaev <teodor@sigaev.ru>
Re: Feeding results back into select "D'Arcy J.M. Cain" <darcy@druid.net>
Re: proposal sql: labeled function params Peter Eisentraut <peter_e@gmx.net>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Gregory Stark <stark@enterprisedb.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params "Greg Stark" <greg.stark@enterprisedb.com>
Re: proposal sql: labeled function params daveg <daveg@sonic.net>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params "Asko Oja" <ascoja@gmail.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params "Asko Oja" <ascoja@gmail.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params "Robert Haas" <robertmhaas@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Robert Haas" <robertmhaas@gmail.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params Peter Eisentraut <peter_e@gmx.net>
Re: [SPAM?]: Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal sql: labeled function params Peter Eisentraut <peter_e@gmx.net>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Hannu Krosing <hannu@2ndQuadrant.com>
Re: proposal sql: labeled function params "Pavel Stehule" <pavel.stehule@gmail.com>
Re: proposal sql: labeled function params Peter Eisentraut <peter_e@gmx.net>
"Pavel Stehule"  writes:
> 2008/8/23 Hannu Krosing :
>> Why not just use some standard record syntax, like

> do you thing, so is it simpler?

It's not about being "simpler", it's about pointing out that there are
ways to do what you need without creating compatibility problems and
without commandeering syntax that, if we were going to commandeer it,
would be far better used for named params.

IMHO, the use-case for labeled parameters is simply much too narrow
to justify giving them special syntax if there is any possible way
to avoid it.  We have now seen a couple of ways to do it without
new syntax, at the cost of a few more lines inside the called function
to examine its arguments.  But the use-cases you've suggested involve
functions that are complicated enough that that's not going to be any
big deal.

So I feel that the proposal for labeled parameters as such is dead
in the water, and that the only usefulness this thread has had is
(re-) exploring the syntactic alternatives available for named params.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Joshua D. Drake
Дата:
От: Tom Lane
Дата:
FAQ