On Thu, Oct 11, 2018 at 05:12:48AM -0400, Corey Huinker wrote: > On Thu, Oct 11, 2018 at 5:04 AM Surafel Temesgen <surafel3...@gmail.com> > wrote: > > > > > > > On Thu, Oct 11, 2018 at 12:00 PM Christoph Moench-Tegeder < > > c...@burggraben.net> wrote: > > > >> You can: > >> COPY ( query ) TO 'filename'; > >> > > it is for COPY FROM > > > > regards > > Surafel > > > > It didn't get far, but you may want to take a look at a rejected patch for > copy_srf() (set returning function) > https://www.postgresql.org/message-id/CADkLM%3DdoeiWQX4AGtDNG4PsWfSXz3ai7kY%3DPZm3sUhsUeev9Bg%40mail.gmail.com > https://commitfest.postgresql.org/12/869/ > > Having a set returning function gives you the full expressiveness of SQL, > at the cost of an extra materialization step.
I wonder whether something JIT-like could elide this. A very interesting subset of such WHEN clauses could be pretty straight-forward to implement in a pretty efficient way. Best, David. -- David Fetter <david(at)fetter(dot)org> http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate