Re: [JDBC] How to set numeric in PreparedStatement

[Aaron Brashears]

On Thu, Mar 22, 2001 at 10:12:16AM +0200, Juhan-Peep Ernits wrote:
> 
> May be this would help?
> 
>      "select id from account where balance > ?::numeric(10,2) and
> balance < ?::numeric(10,2)";
> 
> 
> Juhan Ernits
> 


Perfect! Thank you, it works great.

I've never seen that syntax before, is it part of sql?

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl