"Tim Knowles" <timknowles@ametco.co.uk> writes:
> I have a view which uses 3 subselects (if more info is required I've
> included the my SQL and the view that is created at the end). When I create
> the view the PostgreSQL creates the subselect with two fields (I guess it's
> the group by clause that may be causing this). The view works fine even
> though when I use \d to describe it, it looks like it returns more than one
> field - although it doesn't). However when I use pg_dump to back it up and
> then recreate the db I get an error that the subselect must only have one
> field.
This is fixed in 7.1.
Note that the above is by no means the worst of the problems that
grouped views will give you in 7.0.* and before :-(
regards, tom lane