rob caSSon <rob@styro.lib.muohio.edu> writes:
> i have a perfectly valid sql statement that returns expected results, but
> when i create a view based on the same sql, i get 0.
Your example seems to work fine for me with current sources.
What version are you running?
regards, tom lane