From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Prepared statement with function as argument: how to bind values? |
Date: | 2014-03-25 07:06:23 |
Message-ID: | 1395731183295-5797356.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2014-03-25 07:13:43 | Re: Prepared statement with function as argument: how to bind values? |
Previous Message | Sivakumar | 2014-03-25 06:13:27 | Re: Prepared statement with function as argument: how to bind values? |