Re: Can't compare decimal columns??? - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: Can't compare decimal columns???
Date
Msg-id Pine.LNX.4.30.0101142130190.25523-100000@chapelperilous.net
Whole thread Raw
In response to Re: Can't compare decimal columns???  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
On Sun, 14 Jan 2001, Stephan Szabo wrote:

> I believe there was discussion about these things on -hackers a while
> back.  The type promotion and which type a constant is seen as is kind of
> wierd right now.  The query will probably work with explicit typecast to
> numeric for the constants.

Yes, I got it to work with CAST(? as NUMERIC).  Was just curious about the
operator issue.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Success is in the minds of Fools.
        -- William Wrenshaw, 1578


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating a database
Next
From: Ben Stringer
Date:
Subject: Re: Creating a database