On 05/14/2016 01:47 PM, Andrus wrote:
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)
test=# select *, crtkaive(ko.doktyyp) from ko;
doktyyp | crtkaive
---------+----------
G | 1
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.
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
