Re: How to set numeric in PreparedStatement

From: Aaron Brashears <gila(at)gila(dot)org>
To: Juhan-Peep Ernits <juhan(at)cc(dot)ioc(dot)ee>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: How to set numeric in PreparedStatement
Date: 2001-03-22 19:00:04
Message-ID: 20010322110004.A13214@gila.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mike Cannon-Brookes 2001-03-23 00:37:23 Compiling
Previous Message Philip Yue 2001-03-22 16:45:46 RE: [JDBC] Lost in unicode?