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
|
| Список | 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 по дате отправления: