Hi,
I have an expensive function that does a lot of regex and other text analysis. This function relies on several columns of my table and for efficiency/code reuse also has several OUT arguments:
CREATE OR REPLACE FUNCTION extract_keywords(IN l large_table, OUT a text, OUT b text, OUT c text)
RETURNS record AS
$BODY$
select l.a ~* 'lots of regex' as a, l.b ~* 'lots of regex' as b, l.c ~* 'lots of regex' as c
from large_table l
$BODY$
LANGUAGE sql STABLE;
I want to use this function in a view and since I only want the function to be called once I created my view as such:
create view with_keywords as
select x,y,z, (extract_keywords(l.*)).*
from large_table;
However when I then inspect the generated SQL for the view in pgadmin I get:
CREATE VIEW with_keywords AS
SELECT x,y,z,
(extract_keywords(l.*)).a AS a,
(extract_keywords(l.*)).b AS b,
(extract_keywords(l.*)).c AS c
FROM large_table l;
Thanks,
Daniel
