ROWS FROM(): A Foolish (In)Consistency?

Поиск
Список
Период
Сортировка
От David Fetter
Тема ROWS FROM(): A Foolish (In)Consistency?
Дата
Msg-id 20151019172437.GA30238@fetter.org
обсуждение исходный текст
Ответы Re: ROWS FROM(): A Foolish (In)Consistency?
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: pg_restore cancel TODO
Следующее
От: Robbie Harwood
Дата:
Сообщение: Re: [PATCH v3] GSSAPI encryption support