On Wed, Aug 10, 2016 at 1:19 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> > > 2016-08-10 19:05 GMT+02:00 Alexander Farber <alexander.far...@gmail.com>: > >> Thank you Adrian and others - >> >> I am trying to replace INSERT into temp table in my custom function by >> RETURN NEXT, but get an error: >> >> CREATE OR REPLACE FUNCTION words_check_words( >> IN in_uid integer, >> IN in_gid integer, >> IN in_tiles jsonb) >> RETURNS TABLE(word varchar, score integer) AS >> $func$ >> ....... >> >> -- INSERT INTO _words(word, score) >> -- VALUES (upper(_word), _score); >> >> RETURN NEXT (word, score); >> >> >> ERROR: RETURN NEXT cannot have a parameter in function with OUT >> parameters >> LINE 98: RETURN NEXT (word, score); >> > > This was limit in older version > > He's supposedly using 9.5 which documents "RETURN NEXT expression;" https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html Dave
