Re: Prepared statement with function as argument: how to bind values? - Mailing list pgsql-jdbc

From Maciek Sakrejda
Subject Re: Prepared statement with function as argument: how to bind values?
Date
Msg-id CAH_hXRacBHtR1bX0_VypvXcgtxKG6OKXkBk0BCKew5NyK=S9Eg@mail.gmail.com
Whole thread Raw
In response to Re: Prepared statement with function as argument: how to bind values?  (alexbruy <alexander.bruy@gmail.com>)
List pgsql-jdbc
> As I
> understand, it says about number of columns because there are 5
> columns listed in query and I try to bind value to non existing 6
> column.

As I understand it,

 (1) the parameter handling code doesn't know or care you're executing
an insert, so it shouldn't deal in "columns" here, just in parameters
 (2) the question marks in 'POINT(?,?)' should not be treated as
parameter markers at all: it should just be a String constant.

Can you show us exactly how you're binding parameters in jdbc?
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

pgsql-jdbc by date:

Previous
From: alexbruy
Date:
Subject: Re: Prepared statement with function as argument: how to bind values?
Next
From: Bodor Andras
Date:
Subject: Re: Prepared statement with function as argument: how to bind values?