Kyotaro HORIGUCHI <horiguchi.kyot...@lab.ntt.co.jp> writes: > At least partition bound *must* be a constant. Any expression > that can be reduced to a constant at parse time ought to be > accepted but must not be accepted if not.
My point is that *any* expression can be reduced to a constant, we just have to do so. > Maybe we could explicitly control that by having pseudo functions > like eval(). > ... where sold_date = eval_on_parse('today'); > ... where sold_date = eval_on_exec('today'); This strikes me as far outside the immediate requirements. In fact, if we had such functions, they'd be irrelevant to this requirement. regards, tom lane