On 09/01/2014 10:17 PM, Andres Freund wrote: > Imo this is still something that's more dynamic SQL (i.e. EXECUTE's > remit) than something that shouldn't be doable implicitly. So perhaps > the solution is to extend EXECUTE to allow specifying tablenames as > variables more conveniently?
With format(...) it's pretty easy, really. Perhaps just changing the docs to remove all the quote_ident based examples in favour of format(...) would be enough. Pavel's points are pretty good - what exists now isn't ideal from a usability and friendliness PoV, but changing it would require making a big mess elsewhere that's not worth doing. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers