On 9/1/22 10:08, Tom Lane wrote:
Wesley Schwengle writes:
There is a view that we create and it uses a function and the view
definition changes between runs. I'm not sure why this is happening,
does someone know?
The core reason for the discrepancy is that the parser inserts
imp
tore(ARRAY['bar'::text, 'baz'::text], ARRAY[foo.bar,
foo.baz::character varying]::text[])) AS sometext
FROM foo
);
\d+ foo_view_copy
-- yields as View definition
-- SELECT myfunc(hstore(ARRAY['bar'::text, 'baz'::text],
ARRAY[foo.bar::text, foo.baz::character varying::text])) AS sometext
-- FROM foo;
```
--
Wesley Schwengle, Developer
xxllnc Zaaksysteem, https://www.zaaksysteem.nl
