Re: Re: Comparing fixed precision to floating (no anwer)

From: "Johann Zuschlag" <zuschlag(at)online(dot)de>
To: "Mike Finn" <mike(dot)finn(at)tacticalExecutive(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Comparing fixed precision to floating (no anwer)
Date: 2001-08-23 21:31:05
Message-ID: E15a23F-0008D6-00@mrelay01.kundenserver.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hi Mike

On Thu, 23 Aug 2001 09:08:39 -0600, Mike Finn wrote:

>Your routine is not working becase you have no body in your function.

Well done! It now works. I didn't need to drop the operator, since
there was nothing to drop. :-)

>
>The HACK below does work. I say HACK because
>a) this routine should really should be in C
> as it will executed billions of times when
> used in where clauses (but I am not a "C" programmer)

It's not a hack and it works fine with more than 10.000
datasets. But maybe C would be faster.

>b) I don't really understand the effects/implications
> of the commutator, negator, restrict, and join parameters
> (I simply copied them from your example, and the docs
> were a bit beyond me)
>
Just read the manual. The above is explained in detail.

>Maybe someone listening with a bit more pg savvy can help us out further.

Maybe :-)

regards

Johann

Johann Zuschlag
zuschlag(at)online(dot)de

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2001-08-23 21:46:04 Re: Help Problem mysql ????
Previous Message Murray Hobbs 2001-08-23 20:46:16 Re: protected ON DELETE CASCADE

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-08-23 21:37:27 Re: [PATCHES] JDBC patch for util.Serialize and jdbc2.PreparedStatement
Previous Message Bruce Momjian 2001-08-23 20:31:35 Re: Re: Couple of patches for jdbc driver