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.

"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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match