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
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