On Fri, Feb 14, 2014 at 10:15 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
yeah -- you could do this with some gymnastics and some dynamic SQL.
If I were lazy (check), I would just encode the order in the name of
the view somehow.
Thanks. That's exactly what I do already. Apparently, I'm even lazier than you!
In case anyone out there is looking for a convention, here's one that I find useful: _v for views intended for interactive queries, _dv (defining views) for views that are too slow to use interactively, and _mv for the materialized _dv views.
