Zwracany typ funkcji to "setof searched_text_type" (tak jak w oryginale). Nie mogę znaleźć info w sieci na temat tego typu.
DECLARE row record; BEGIN RETURN query ( SELECT * FROM (SELECT * FROM table_full_text_search(_language, _query) AS (id integer,table_name character varying,rank real)) AS text LEFT JOIN table_accomodations_i18n AS mtsacc ON mtsacc.accomodations_id=text.id AND text.table_name='table_accomodations_i18n' AND mtsacc.language_code=_language LEFT JOIN table_accomodations_packages_i18n AS mtsaccpac ON mtsaccpac.package_id=text.id AND text.table_name='table_accomodations_packages_i18n' AND mtsaccpac.language_code=_language ..... TU DALSZE JOIN ..... ); END;
Używam pgadmin na PostgreSQL 8.4.3