How to use row values as function parameters

Поиск
Список
Период
Сортировка
Искать
От
Andrus
Тема
How to use row values as function parameters
Дата
в 20:48:04
Msg-id
B47E614A2DB74E17B92A42DCFDD74AC9@dell2
Ответ на
Список
Дерево обсуждения
Converting char to varchar automatically "Andrus" <kobruleht2@hot.ee>
Re: Converting char to varchar automatically Andy Colson <andy@squeakycode.net>
How to use record variable with non-null domain in plpgsql "Andrus" <kobruleht2@hot.ee>
Re: How to use record variable with non-null domain in plpgsql Tom Lane <tgl@sss.pgh.pa.us>
How to speed up delete where not in "Andrus" <kobruleht2@hot.ee>
Re: How to speed up delete where not in David Rowley <david.rowley@2ndquadrant.com>
How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Ynt: How to drop user if objects depend on it Neslisah Demirci <neslisah.demirci@markafoni.com>
Re: Ynt: How to drop user if objects depend on it Jerry Sievers <gsievers19@comcast.net>
Re: How to drop user if objects depend on it Thom Brown <thom@linux.com>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Adrian Klaver <adrian.klaver@aklaver.com>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Tom Lane <tgl@sss.pgh.pa.us>
Re: How to drop user if objects depend on it Tom Lane <tgl@sss.pgh.pa.us>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Tom Lane <tgl@sss.pgh.pa.us>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Tom Lane <tgl@sss.pgh.pa.us>
How to get correct local time "Andrus" <kobruleht2@hot.ee>
Re: How to get correct local time Vitaly Burovoy <vitaly.burovoy@gmail.com>
Re: How to get correct local time Vitaly Burovoy <vitaly.burovoy@gmail.com>
Re: How to get correct local time Adrian Klaver <adrian.klaver@aklaver.com>
How to use row values as function parameters "Andrus" <kobruleht2@hot.ee>
Re: How to use row values as function parameters Adrian Klaver <adrian.klaver@aklaver.com>
Re: How to use row values as function parameters "David G. Johnston" <david.g.johnston@gmail.com>
Re: How to use row values as function parameters "Andrus" <kobruleht2@hot.ee>
Re: How to use row values as function parameters Adrian Klaver <adrian.klaver@aklaver.com>
Re: How to use row values as function parameters "David G. Johnston" <david.g.johnston@gmail.com>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Adrian Klaver <adrian.klaver@aklaver.com>
Re: How to drop user if objects depend on it Melvin Davidson <melvin6925@gmail.com>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Melvin Davidson <melvin6925@gmail.com>
Re: How to drop user if objects depend on it "Andrus" <kobruleht2@hot.ee>
Re: How to drop user if objects depend on it Melvin Davidson <melvin6925@gmail.com>
Re: How to speed up delete where not in Melvin Davidson <melvin6925@gmail.com>
Re: How to use record variable with non-null domain in plpgsql "Andrus" <kobruleht2@hot.ee>
Re: Converting char to varchar automatically Melvin Davidson <melvin6925@gmail.com>
Re: Converting char to varchar automatically "Andrus" <kobruleht2@hot.ee>
Re: Converting char to varchar automatically "Andrus" <kobruleht2@hot.ee>
Re: Converting char to varchar automatically Melvin Davidson <melvin6925@gmail.com>
Re: Converting char to varchar automatically "Andrus" <kobruleht2@hot.ee>
Re: Converting char to varchar automatically Melvin Davidson <melvin6925@gmail.com>
Re: Converting char to varchar automatically "Andrus" <kobruleht2@hot.ee>
Re: Converting char to varchar automatically Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Converting char to varchar automatically "Andrus" <kobruleht2@hot.ee>
Table ko should used to pass parameters to crtKAIVE() function.
ko has always single row.

I tried

CREATE or replace FUNCTION public.crtKAIVE(
_doktyybid text default 'GVY'
)
RETURNS TABLE (
id integer
)
AS $f_crkaive$
select 1
$f_crkaive$ LANGUAGE sql STABLE;

create temp  table ko ( doktyyp text ) on commit drop;
insert into ko values ('G');
select * from ko, crtkaive(ko.doktyyp)

but got error

    ERROR:  function expression in FROM cannot refer to other relations of 
same query level

How to fix this so that ko can used to pass parameters to crtkaive ?

Posted also in

http://stackoverflow.com/questions/37231624/how-to-use-table-row-values-as-function-parameters

Andrus. 


В списке pgsql-general по дате отправления
От: Boszormenyi Zoltan
Дата:
Сообщение: PG wire protocol question
От: David G. Johnston
Дата:
FAQ