Why, when I save a simple view like:
SELECT * FROM a_table
…does PostgreSQL turn the * into a field list like:
SELECT field1, field2, field3, field4 FROM a_table
Yes, deeply nesting views is a maintenance concern. It works this way so the view remains stable (there may be others, the reasoning no longer really matters...). If you really want dynamic SQL you will need to use a function.
David J.
