Hi there,
I have a query unions two subqueries which each returns a row with an id and
a long text and "order by id asc". The row with a smaller id follows the
other row with a larger id. However, every time when I tried to read the
text of the smaller id, it was never read and the text of the larger id was
returned. The resultset pointer seemed to stay at the first row with larger
id regardless how many times rs.next() was executed (three times of
execution but not errors occurred). I figured out that the problem was with
reading the long text, or the query could not handle that. The query was
executed successfully in psql environment. My question is: how to read a
text field (particularly with long value), can I treat it as a clob but
PostgreSQL does not support clob?
Thanks.
Daniel Huang