"Dickson S. Guedes" <lis...@guedesoft.net> writes:
> And bellow is the select that returns: "ERROR: failed to locate grouping
> columns"
> when no rows is returned by the View above, but it runs well when one or more
> rows is returned by same view.
I really have a hard time believing that whether you get that error is
contingent on whether the view returns some rows or not. That's a
planner message and couldn't possibly have to do with what happens
at runtime.
Would you put together a complete example, instead of leaving us to
guess what's underlying the view? And what PG version is this?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
