Postgres Pro
Downloads
Home   >   mailing lists

Re: How to set numeric in PreparedStatement - Mailing list pgsql-jdbc

From Aaron Brashears
Subject Re: How to set numeric in PreparedStatement
Date
Msg-id 20010322110004.A13214@gila.org
Whole thread Raw
In response to Re: How to set numeric in PreparedStatement  (Juhan-Peep Ernits <juhan@cc.ioc.ee>)
List pgsql-jdbc
Tree view 
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?

pgsql-jdbc by date:

Previous
From: "Philip Yue"
Date:
Subject: RE: Lost in unicode?
Next
From: "Mike Cannon-Brookes"
Date:
Subject: Compiling