Re: cursor empty

2018-05-08 Thread Philipp Kraus
Am 08.05.2018 um 16:18 schrieb David G. Johnston mailto:david.g.johns...@gmail.com>>: On Tue, May 8, 2018 at 6:36 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: select * from vectorize('myvec'); fetch all from myvec; Can you explain me, which part is wrong? I am going to say: p

Re: cursor empty

2018-05-08 Thread David G. Johnston
On Tue, May 8, 2018 at 6:36 AM, Adrian Klaver wrote: > >> select * from vectorize('myvec'); >> fetch all from myvec; >> >> Can you explain me, which part is wrong? >> > > I am going to say: > > perform pivottable( ... > > https://www.postgresql.org/docs/10/static/plpgsql-statements > .html#PLPGSQ

Re: cursor empty

2018-05-08 Thread Adrian Klaver
On 05/08/2018 05:39 AM, Philipp Kraus wrote: Hello, I have got a function with this definition: CREATE OR REPLACE FUNCTION vectorize(refcursor) RETURNS SETOF refcursor LANGUAGE 'plpgsql' COST 100 STABLE ROWS 1000 AS $BODY$ begin perform pivottable(