are long strings (500 char?) working?

From: Heitzso <heitzso(at)home(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: are long strings (500 char?) working?
Date: 2001-10-01 15:33:27
Message-ID: 3BB88CC7.3080108@home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I've tried using both PreparedStatement and regular Statement
modes with a 450 character string:

SELECT response, last_requested
FROM dataweb_response_cache
WHERE request = 'long string here'

and

SELECT response, last_requested
FROM dataweb_response_cache
WHERE request = ?
(PreparedStatement form)

and I consistenly get parse error around
LIKE or = (I've tried both)

though the same query works fine in
short string form anyway with psql
(haven't tried long string form, will
if advised). The short string I substituted
for the long string otherwise had all
of the quirks of the long string

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heitzso 2001-10-01 15:36:54 are \r \n and \t legal in
Previous Message Bruce Momjian 2001-09-29 18:16:38 Re: anonymous cvs change ?