Re: Prepared statement with function as argument: how to bind values?

Sivakumar wrote
> I think it's too late to respond for this issue, but i hope it will be
> useful for someone else. I also faced the same issue of binding, how i
> solved is
>
>
> String sql = "INSERT INTO
> poi(geom,latitude,longitude,description,comment) VALUES
> (
*
> ST_GeomFromText(?, 4326)
*
> , ?, ?, ?, ?)";
> stmt = conn.prepareStatement(sql);
*
> stmt.setString(1, "POINT(" +lon + " " + lat + ")");
*
> stmt.setFloat(2, lon);
> stmt.setFloat(3, lat);
> stmt.setTimestamp(4, descr);
> stmt.setString(5, comment);
>
> Thanks,
> Sivakumar

Doesn't seem that much an improvement over dynamic SQL.

INSERT INTO ...
SELECT func_outer(func_inner(val1, val2), 4326), val3
FROM (VALUES (?,?,?)) src (val1,val2,val3);

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Prepared-statement-with-function-as-argument-how-to-bind-values-tp4833351p5797356.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.