Request a Demo
Home   >   mailing lists

Using INET types in prepared statements - Mailing list pgsql-sql

From LITTLE Nelson
Subject Using INET types in prepared statements
Date
Msg-id 200706130203.l5D23Cs2026506@sprint2.tenix.com
Whole thread
Responses Re: Using INET types in prepared statements
List pgsql-sql
Tree view

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

 

 

pgsql-sql by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: cluster index on primary key
Next
From: Tom Lane
Date:
Subject: Re: Using INET types in prepared statements