Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm
От
Pavel Stehule
Тема
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm
Дата
Msg-id
BAY20-F2301EBABA30700C408681EF93E0@phx.gbl
Ответ на
Список
Дерево обсуждения
PLpgSQL: list of scalars as row for assign stmt, fore and fors stms "Pavel Stehule" <pavel.stehule@hotmail.com>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stms Tom Lane <tgl@sss.pgh.pa.us>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stms "Andrew Dunstan" <andrew@dunslane.net>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm "Pavel Stehule" <pavel.stehule@hotmail.com>
Re: PLpgSQL: list of scalars as row for assign stmt, fore Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: PLpgSQL: list of scalars as row for assign stmt, fore David Fetter <david@fetter.org>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm "Pavel Stehule" <pavel.stehule@hotmail.com>
Re: PLpgSQL: list of scalars as row for assign stmt, fore Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm Tom Lane <tgl@sss.pgh.pa.us>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm "Pavel Stehule" <pavel.stehule@hotmail.com>
Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm "Pavel Stehule" <pavel.stehule@hotmail.com>
> >"Pavel Stehule" writes: > > x, y := r; > >That strikes me as a really bad idea. It weakens both syntax and >semantic error checking, to accomplish how much? > It's same as select into or execute into (using same code). And behave is like row variable := row variable. I am not sure if it's good idea. But it's can be usefull when you have out variables and you have to fill them. There are not control for count of arguments, but types are checked. I can understand so this topic is little bit controvers. And maybe we don't need this statements, if we have this possibility in fore and fors stmts. Regards Pavel Stehule _________________________________________________________________ Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/
В списке pgsql-patches по дате отправления
От: Pavel Stehule
Дата: