Re: RETURNS TABLE function: ERROR: column reference "word" is ambiguous
От | Alexander Farber |
---|---|
Тема | Re: RETURNS TABLE function: ERROR: column reference "word" is ambiguous |
Дата | |
Msg-id | CAADeyWhHsMsX6UqfEn29BAgbfHq1Hpgi2Hcx_L+Y6OTQA9cVKw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: RETURNS TABLE function: ERROR: column reference "word" is ambiguous (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: RETURNS TABLE function: ERROR: column reference "word"
is ambiguous
Re: RETURNS TABLE function: ERROR: column reference "word" is ambiguous |
Список | pgsql-general |
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:
-- 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);
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(-- INSERT INTO _words(word, score)
IN in_uid integer,
IN in_gid integer,
IN in_tiles jsonb)
RETURNS TABLE(word varchar, score integer) AS
$func$
.......
-- 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);
Regards
Alex
В списке pgsql-general по дате отправления: