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
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 also