Re: Operator to compare numeric and double precision

From: Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
To: Terry Yapt <pgsql(at)technovell(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Operator to compare numeric and double precision
Date: 2002-10-28 07:43:59
Message-ID: 20021028084359.7ed79396.christoph.dalitz@hs-niederrhein.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-10-28 07:54:14 Re: performance issue
Previous Message Savita 2002-10-28 07:20:24 Re: performance issue