Re: Operator to compare numeric and double precision

Hi Christoph,

I cannot use CAST in this exact example. I have _only_ be able to
change the operator in the whole expression...

I mean:

a = b (give me the error, because a=numeric and b=double precision)

I need something like (for example):
a =!= b (an _equal_ operator which support a numeric and double
precision operands).. I am inventing this '=!=' operator type...

Thanks...

Christoph Dalitz wrote:
>
> > Date: Sun, 27 Oct 2002 13:02:38 +0100
> > From: Terry Yapt <pgsql(at)technovell(dot)com>
> >
> > Are there any operator to compare numeric with double precision ?
> >
> Try the SQL-Function CAST (its part of the SQL2 standard), eg.
>
> ... WHERE doublefield = (CAST numericfield AS DOUBLE) ...
>
> I don't know whether ODBC supports SQL-Functions directly; you will
> probably need to use the "PASSTHROUGH" parameter.
>
> Hope this helps,
>
> Christoph Dalitz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)