rob caSSon <rob(at)styro(dot)lib(dot)muohio(dot)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