pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUse of bytea
5+ messages / 2 participants
[nested] [flat]
* Use of bytea
@ 2004-12-04 15:26 Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 13:22 ` Re: Use of bytea Oliver Jowett <oliver@opencloud.com>
0 siblings, 1 reply; 5+ messages in thread
From: Chris White (cjwhite) @ 2004-12-04 15:26 UTC (permalink / raw)
To: pgsql-jdbc@postgresql.org; +Cc: pgsql-admin
Is it possible in jdbc to use a bytea column in a where clause and compare
it to byte[] object?
Chris White
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Use of bytea
2004-12-04 15:26 Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-12-05 13:22 ` Oliver Jowett <oliver@opencloud.com>
2004-12-05 19:24 ` Re: Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
0 siblings, 1 reply; 5+ messages in thread
From: Oliver Jowett @ 2004-12-05 13:22 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-jdbc@postgresql.org
Chris White (cjwhite) wrote:
> Is it possible in jdbc to use a bytea column in a where clause and
> compare it to byte[] object?
Yes.
-O
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Use of bytea
2004-12-04 15:26 Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 13:22 ` Re: Use of bytea Oliver Jowett <oliver@opencloud.com>
@ 2004-12-05 19:24 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 19:36 ` Re: Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
0 siblings, 1 reply; 5+ messages in thread
From: Chris White (cjwhite) @ 2004-12-05 19:24 UTC (permalink / raw)
To: 'Oliver Jowett' <oliver@opencloud.com>; +Cc: pgsql-jdbc@postgresql.org
How? Can you give me an example.
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Oliver Jowett
Sent: Sunday, December 05, 2004 5:23 AM
To: cjwhite@cisco.com
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Use of bytea
Chris White (cjwhite) wrote:
> Is it possible in jdbc to use a bytea column in a where clause and
> compare it to byte[] object?
Yes.
-O
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Use of bytea
2004-12-04 15:26 Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 13:22 ` Re: Use of bytea Oliver Jowett <oliver@opencloud.com>
2004-12-05 19:24 ` Re: Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-12-05 19:36 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 21:22 ` Re: Use of bytea Oliver Jowett <oliver@opencloud.com>
0 siblings, 1 reply; 5+ messages in thread
From: Chris White (cjwhite) @ 2004-12-05 19:36 UTC (permalink / raw)
To: cjwhite@cisco.com; 'Oliver Jowett' <oliver@opencloud.com>; +Cc: pgsql-jdbc@postgresql.org
Do not worry just realized how to do it using PreparedStatement.
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Chris White (cjwhite)
Sent: Sunday, December 05, 2004 11:24 AM
To: 'Oliver Jowett'
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Use of bytea
How? Can you give me an example.
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Oliver Jowett
Sent: Sunday, December 05, 2004 5:23 AM
To: cjwhite@cisco.com
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Use of bytea
Chris White (cjwhite) wrote:
> Is it possible in jdbc to use a bytea column in a where clause and
> compare it to byte[] object?
Yes.
-O
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Use of bytea
2004-12-04 15:26 Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 13:22 ` Re: Use of bytea Oliver Jowett <oliver@opencloud.com>
2004-12-05 19:24 ` Re: Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 19:36 ` Re: Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-12-05 21:22 ` Oliver Jowett <oliver@opencloud.com>
0 siblings, 0 replies; 5+ messages in thread
From: Oliver Jowett @ 2004-12-05 21:22 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-jdbc@postgresql.org
Chris White (cjwhite) wrote:
> Do not worry just realized how to do it using PreparedStatement.
Ah, sorry, I thought you were just asking if the driver would handle it.
Yeah, just use PreparedStatement.setBytes(). We use bytea values in
where clauses in this way with no problems.
-O
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-12-05 21:22 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-04 15:26 Use of bytea Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 13:22 ` Oliver Jowett <oliver@opencloud.com>
2004-12-05 19:24 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 19:36 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-12-05 21:22 ` Oliver Jowett <oliver@opencloud.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox