Joel Burton writes:
> I have a function that takes two text parameters. If both of these
> are non-null, everything works fine. However, if one of these two
> parameters is null and one is not, the function receives both as null.
Worse, no matter what the function does, the return value is als
Philip Warner <[EMAIL PROTECTED]> writes:
> It seems that the optimizer does not know about (or calculate values of)
> constant expressions when determining strategy.
Datetime calculations are not considered constant-foldable. See
prior discussions, eg thread "Constant propagation and similar is
Keith Wong writes:
> Anybody know how to compile pgaccess from postgres source files?
> It must be a configure option, but I can't find it.
--with-tcl --with-x
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
It seems that the optimizer does not know about (or calculate values of)
constant expressions when determining strategy. Perhaps I am doing
something silly, but:
select tmax from ping where pingtime > current_timestamp - interval '2
hour'
order by pingtime asc limit 30;
is very slo
