From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | ROWS FROM(): A Foolish (In)Consistency? |
Date: | 2015-10-19 17:24:37 |
Message-ID: | 20151019172437.GA30238@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Robbie Harwood | 2015-10-19 18:01:01 | Re: [PATCH v3] GSSAPI encryption support |
Previous Message | Jeff Janes | 2015-10-19 16:47:04 | Re: pg_restore cancel TODO |