Michael, Fuhr wrote:
The errors were the following:
template1=# SELECT 'NaN'::float4;
ERROR: 22003: type "real" value out of range: overflow
LOCATION: CheckFloat4Val, float.c:219
The code around float.c:219 looks like this:
if (fabs(val) > FLOAT4_MAX)
ereport(ERROR,
Matthew Wakeling <[EMAIL PROTECTED]> writes:
> [ snip... ]
> If we remove the limit, then the planner switches to this query plan:
> Limit (cost=156.24..156.26 rows=10 width=14)
... which still has a limit. I think you have made several cut-and-paste
errors here, because the plans you are exhib
Tom Lane wrote:
> Rolf Sponsel <[EMAIL PROTECTED]> writes:
> > From my understanding, the preferred way
> > for Solaris is to only set LD_RUN_PATH,
> > and avoid setting LD_LIBRARY_PATH, at
> > link-time. This is what I usually do.
>
> No, the preferred thing is to set -rpath within the executable