Добрый день, при select f.*, routeid from cast(regexp_split_to_table( '296,292,419,342,336,341,374,433,413,366,409,412,298,340,339,398,401,426,326,306,395,256,411,271,393,358,356,286,278,329,425,353,432,274,379,267,360,305,399,397,281,328,408,282,333,273,385,344,421,371,354,423,410,348,384,300,368,370,313,403,258,363,322,285,428,334,320,297,383,269,302,407,405,380,435,257,388,350,295,321,319,391,375,317,318,293,294,359,373,288,303,331,283,424,315,406,417,381,427,323,369,367,270,422,382,345,261,335,349,351,301,332,396,309,307,436,415,312,255,343,402,361,290,259,325,316,437,272,311,372,287,262,376,400,337,392,365,299,284,280,308,347,364,352,390,430,330,414,268,314,291,304,434,377,362,420,265,275,387,429,357,404,131,394,289,378,386,266,327,355,276,310,338,346,324,263',',') as integer) as routeid

Question

Добрый день, при select f.*, routeid from cast(regexp_split_to_table( '296,292,419,342,336,341,374,433,413,366,409,412,298,340,339,398,401,426,326,306,395,256,411,271,393,358,356,286,278,329,425,353,432,274,379,267,360,305,399,397,281,328,408,282,333,273,385,344,421,371,354,423,410,348,384,300,368,370,313,403,258,363,322,285,428,334,320,297,383,269,302,407,405,380,435,257,388,350,295,321,319,391,375,317,318,293,294,359,373,288,303,331,283,424,315,406,417,381,427,323,369,367,270,422,382,345,261,335,349,351,301,332,396,309,307,436,415,312,255,343,402,361,290,259,325,316,437,272,311,372,287,262,376,400,337,392,365,299,284,280,308,347,364,352,390,430,330,414,268,314,291,304,434,377,362,420,265,275,387,429,357,404,131,394,289,378,386,266,327,355,276,310,338,346,324,263',',') as integer) as routeid

join f_status_stops_for_vector(routeid) f ON true
возвращает ошибку
[0A000] ERROR: set-returning functions must appear at top level of FROM Position: 31
подскажите что не так?

#backend #devops #pgsql #programming #russian

0

18.03.2020

1 ответов

10 просмотров

Yaroslav Schekin · Accepted Answer

Yaroslav Schekin

Прямо то, что написано. Перепишите так, чтобы это условие соблюдалось (IMHO, было бы хорошо, если бы SRF в SELECT list не работали вообще — одна путаница от этого).

0

18.03.2020

172 похожих чатов

1 ответов

Похожие вопросы