pgsql-bugs(at)postgresql(dot)org writes:
> postgresql process crashes on select * from cmd_sm (which is a view)
Poking into this revealed what seems to be a long-standing bug: a view
that uses BETWEEN gets confused about any variables appearing in the
first argument of the BETWEEN. I've fixed this in current sources,
but for 7.0.* you'd be best advised to write out BETWEEN explicitly
as "a >= b AND a <= c".
A separate issue is that grouped views don't work very well in 7.0.*.
This is also fixed for 7.1, but in the meantime don't expect to be able
to apply aggregates or grouping to the output of a grouped view.
regards, tom lane