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  (Dave Cramer <pg@fastcrypt.com>)
Re: Opening view that uses a function - empty column  (Brady Mathis <bmathis@r-hsoftware.com>)
Re: Opening view that uses a function - empty column  (Brady Mathis <bmathis@r-hsoftware.com>)
Список 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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: upgrade causes psql to not work
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Opening view that uses a function - empty column