Re: Opening view that uses a function - empty column

Поиск
Список
Период
Сортировка
От Brady Mathis
Тема Re: Opening view that uses a function - empty column
Дата
Msg-id d3ee6832-c364-45a9-9d20-d7dd003a53bd@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  (David Johnston <polobo@yahoo.com>)
Список pgsql-jdbc
I am actually using Jasper reports to access the view.  I created the data source and specified the following:

Driver:  org.postgresql.Driver
URL:  jdbc:postgresql://localhost:5432/postgres
UID and PW

I made sure to update to postgresql-9.1-902.jdbc4.jar (PG version is 9.1.2)

Then I defined a query simply as:

select * from encounter;

I also tried the same query using a SquirrelSQL client (just to eliminate a problem in Jasper) and got the same result.
The column filled by the function is empty. 

If I select * from encounter directly in postgres, the column is filled.

My apologies if I haven't included the implementation details that you need.

Thanks!

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Opening view that uses a function - empty column
Следующее
От: David Johnston
Дата:
Сообщение: Re: Opening view that uses a function - empty column