Opening view that uses a function - empty column
От | Brady Mathis |
---|---|
Тема | Opening view that uses a function - empty column |
Дата | |
Msg-id | aec845f8-15f2-41c6-b1d3-04de5b6889ea@googlegroups.com обсуждение исходный текст |
Ответы |
Re: Opening view that uses a function - empty column
Re: Opening view that uses a function - empty column Re: Opening view that uses a function - empty column |
Список | pgsql-jdbc |
Two step inquiry: 1) I have created a function that will parse a value out of XML stored in the pg_largeobject table using xpath, like so: CREATE OR REPLACE FUNCTION extract_from_extended(text, bigint) RETURNS text AS $BODY$ select translate( xpath(...) ); $BODY$ LANGUAGE sql VOLATILE COST 100; 2) I then created a view that calls this function as part of the query, like so: CREATE OR REPLACE VIEW encounter AS SELECT md.account_id, extract_from_extended('externalEncounterID'::text, md.id) AS external_id... FROM app.menu_data md, app.menu_structure ms WHERE...; When I open this view via JDBC, there is no data in the column that is filled by the function call. Any thoughts? TIA, BRady
В списке pgsql-jdbc по дате отправления: