Re: [HACKERS] GSoC 2017: Foreign Key Arrays

Поиск
Список
Период
Сортировка
Искать
От
Mark Rofail
Тема
Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Дата
Msg-id
CAJvoCuvi8JREomcteEpy3LQ3m=w0TuPUj4B9vwuJE_+3kSqAPA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
[HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
[HACKERS] regproc and when to schema-qualify Chapman Flack <chap@anastigmatix.net>
Re: [HACKERS] regproc and when to schema-qualify Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Re: [HACKERS] GSoC 2017: Foreign Key Arrays David Steele <david@pgmasters.net>
Re: Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays David Steele <david@pgmasters.net>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu <zyu@yugabyte.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: GSoC 2017: Foreign Key Arrays Joel Jacobson <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu <zyu@yugabyte.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu <zyu@yugabyte.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Enrique Meneses <emmeneses@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
On Mon, Nov 13, 2017 at 2:41 AM, Andreas Karlsson <andreas@proxel.se> wrote:
I think the code would look cleaner if you generate the following query:

SELECT fk.x, fk.ys FROM ONLY t2 fk CROSS JOIN LATERAL pg_catalog.unnest(ys) a2 (v) LEFT OUTER JOIN ONLY t1 pk ON pk.x = fk.x AND pk.y = a2.v WHERE [...]

rather than:

SELECT fk.k1, fk.ak2 FROM (SELECT x k1, pg_catalog.unnest(ys) k2, ys ak2 FROM ONLY t2) fk LEFT OUTER JOIN ONLY t1 pk ON pk.x = fk.k1 AND pk.y = fk.k2 WHERE [...]

Andreas has kindly written the SQL query for us. My problem is generating it with C code

Best Regards,
Mark Rofail
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Peter Eisentraut
Дата:
FAQ