Re: Numeric Problem - Mailing list pgadmin-support

From Dave Page
Subject Re: Numeric Problem
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8128C01@mail.vale-housing.co.uk
Whole thread Raw
In response to Numeric Problem  ("jack" <datactrl@tpg.com.au>)
List pgadmin-support

> -----Original Message-----
> From: jack [mailto:datactrl@tpg.com.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.

pgadmin-support by date:

Previous
From: "Savita"
Date:
Subject: Urgent- pgAdmin II problem
Next
From: "Dave Page"
Date:
Subject: Re: Data Migration Wizard & FoxPro memo - revisited