Re: Numeric Problem

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "jack" <datactrl(at)tpg(dot)com(dot)au>, "pgadmin" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Numeric Problem
Date: 2002-11-14 08:45:00
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128C01@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: jack [mailto:datactrl(at)tpg(dot)com(dot)au]
> Sent: 14 November 2002 01:57
> To: pgadmin
> Subject: [pgadmin-support] Numeric Problem
>
>
> Dave,
>
> I'm using pgAdmin II version 1.3.82 , psqlODBC 7.2.3 ,
> postgreSQl 7.2.1. There is a problem when I do an SQL query
> with a field of numeric, for eample NUMERIC (10.2). Following
> staement causes an error such as "Unable to indentify an
> operator '>' for type 'numeric' and 'double precision'..."
>
> select itemNo, listprice from itmt_info
> where listprice > 50.99;
>
> And this one works.
>
> select itemNo, listprice from itmt_info
> where listprice > '50.99';
>
> I think it could be psqlODBC's problem. Would you please
> check this problem. Thnak you!

No, it is PostgreSQL complaining that there is no numeric > float
operator available. You will need to create one, but here is not the
place to ask about that - try looking in the PostgreSQL docs included
with pgAdmin or using one of the PostgreSQL mailling lists.

Regards, Dave.

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-11-14 08:46:16 Re: Data Migration Wizard & FoxPro memo - revisited
Previous Message Savita 2002-11-14 08:25:49 Urgent- pgAdmin II problem