pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing INET types in prepared statements
2+ messages / 2 participants
[nested] [flat]
* Using INET types in prepared statements
@ 2007-06-13 02:03 LITTLE Nelson <nelson.little@tenix.com>
0 siblings, 1 reply; 2+ messages in thread
From: LITTLE Nelson @ 2007-06-13 02:03 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am trying to create a prepared statement in JAVA via JDBC and one of
the parameters I need to set in the SQL statement is of type INET. As
there is no setInet() method how do I pass in the INET value into the
sql statement?
I have tried this:
" WHERE b.ip = ?::inet"
But I get "org.postgresql.util.PSQLException: ERROR: cannot cast type
character varying to inet"
I also tried
" WHERE b.ip = ?"
And I get "org.postgresql.util.PSQLException: ERROR: cannot cast type
character varying to inet"
I really want to use prepared statement as I have to run this SQL
statement over and over and it is supposed to be more efficient.
Can anyone help?
Cheers,
Nelson
Disclaimer :
The contents of this e-mail including any attachments are intended only
for the person or entity to which this e-mail is addressed. If you are not,
or believe you may not be, the intended recipient, please advise the sender
immediately by return e-mail, delete this e-mail and destroy any copies.
Tenix does not warrant nor guarantee that this email communication is free
from errors, virus, interception or interference.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Using INET types in prepared statements
@ 2007-06-13 02:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: LITTLE Nelson <nelson.little@tenix.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-06-13 02:45 UTC (permalink / raw)
To: LITTLE Nelson <nelson.little@tenix.com>; +Cc: pgsql-sql
"LITTLE Nelson" <nelson.little@tenix.com> writes:
> I am trying to create a prepared statement in JAVA via JDBC and one of
> the parameters I need to set in the SQL statement is of type INET. As
> there is no setInet() method how do I pass in the INET value into the
> sql statement?
You'd probably get a more informed response on the pgsql-jdbc list.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-06-13 02:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-13 02:03 Using INET types in prepared statements LITTLE Nelson <nelson.little@tenix.com>
2007-06-13 02:45 ` Tom Lane <tgl@sss.pgh.pa.us>
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