[SQL] Using INET types in prepared statements

2007-06-12 Thread LITTLE Nelson
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

Re: [SQL] Using INET types in prepared statements

2007-06-12 Thread Tom Lane
"LITTLE Nelson" <[EMAIL PROTECTED]> 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