how to read a long text from a text field?

From: "Daniel Huang" <huang(at)pointdx(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: how to read a long text from a text field?
Date: 2003-12-09 05:01:37
Message-ID: KLEKIJFOLILDIMBCFBMOEENOCAAA.huang@pointdx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-12-09 05:22:43 Re: how to read a long text from a text field?
Previous Message TANIDA Yutaka 2003-12-09 04:15:42 Re: CMP Bean problem