ROWS FROM(): A Foolish (In)Consistency? - Mailing list pgsql-hackers

From David Fetter
Subject ROWS FROM(): A Foolish (In)Consistency?
Date
Msg-id 20151019172437.GA30238@fetter.org
Whole thread Raw
Responses Re: ROWS FROM(): A Foolish (In)Consistency?  (David Fetter <david@fetter.org>)
List pgsql-hackers
Folks,

As I was learning how best to add native weighted statistics, coming
soon, I noticed that our ROWS FROM() constructor takes only
set-returning functions, gluing the outputs together side by side
without a join condition of any kind.  This is a handy capability,
which I don't find elsewhere in our code, modulo horrible things
involving WITH ORDINALITY and FULL JOIN.

Did I miss something?

If not, would it make sense to allow every set-returning construct
inside ROWS FROM(), rather than just some of them?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: pg_restore cancel TODO
Next
From: Robbie Harwood
Date:
Subject: Re: [PATCH v3] GSSAPI encryption support