Skip site navigation (1) Skip section navigation (2)

Re: random escape function

From: "Xavier Poinsard" <xpoinsard(at)free(dot)fr>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: random escape function
Date: 2007-04-11 08:51:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Ok, you can remove this mapping.

Kris Jurka a écrit :
> The escape function {fn rand(param)} isn't working on 8.3 servers
> because setseed has been changed to return void and reading the JDBC
> spec, I'm not sure it ever worked as required.
> We map "SELECT {fn rand(0.5)}" to "SELECT setseed(0.5)*0+random()" which
> worked in previous servers because the setseed call returned an int. 
> Now we get "ERROR: operator does not exist: void * integer".  So that's
> our immediate problem, but looking a little closer at the spec shows
> that rand is supposed to take an integer argument, not a float limited
> to 0->1.  So at minimum we'd need to remap the parameter range.
> Also the spec doesn't say what rand is actually supposed to do.  What is
> the purpose of providing a rand function if you have to supply a seed
> every single time.  The seed has to be random, so where does that come
> from?  Is the idea that you pass the same seed every time and get the
> next value from that seed's stream?
> Given the above functional and definitional problems I think the easiest
> course of action is to simply remove the mapping.
> Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Hartmut BenzDate: 2007-04-11 10:52:42
Subject: Re: Small addition to PGInterval
Previous:From: Radim Kolar SF.NETDate: 2007-04-11 08:31:34
Subject: scrollable result sets performance problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group