Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling)

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Andres Freund <andres(at)anarazel(dot)de>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling)
Date:	2017-01-18 20:24:32
Message-ID:	22709.1484771072@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2016-05-23 00:53:27 from Andres Freund <andres(at)anarazel(dot)de>  2016-05-23 01:26:03 from Craig Ringer <craig(at)2ndquadrant(dot)com>   2016-08-22 19:01:01 from Andres Freund <andres(at)anarazel(dot)de>  2016-05-23 02:09:25 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>  2016-05-23 17:10:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2016-05-23 17:35:10 from David Fetter <david(at)fetter(dot)org>    2016-05-23 17:36:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-05-23 17:44:20 from David Fetter <david(at)fetter(dot)org>      2016-05-23 18:27:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2016-05-23 18:30:13 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>   2016-05-23 18:28:11 from Merlin Moncure <mmoncure(at)gmail(dot)com>    2016-05-23 19:13:44 from David Fetter <david(at)fetter(dot)org>     2016-05-23 19:39:54 from Merlin Moncure <mmoncure(at)gmail(dot)com>      2016-05-23 19:58:20 from Joe Conway <mail(at)joeconway(dot)com>       2016-05-23 20:17:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2016-05-23 20:24:45 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>         2016-05-23 20:33:41 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>          2016-05-23 20:42:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-05-23 21:37:06 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>            2016-05-23 21:58:51 from Joe Conway <mail(at)joeconway(dot)com>      2016-05-23 20:05:03 from David Fetter <david(at)fetter(dot)org>       2016-05-23 20:17:15 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>      2016-05-23 20:15:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2016-05-23 20:32:07 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>       2016-06-06 15:30:54 from Robert Haas <robertmhaas(at)gmail(dot)com>        2016-06-06 15:50:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-06-06 16:30:31 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>          2016-06-06 16:40:05 from Vik Fearing <vik(at)2ndquadrant(dot)fr>          2016-06-06 16:41:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-06-06 18:15:56 from Robert Haas <robertmhaas(at)gmail(dot)com>          2016-06-06 18:31:32 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>           2016-06-06 18:48:27 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>           2016-06-06 18:53:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2016-06-06 19:06:37 from Robert Haas <robertmhaas(at)gmail(dot)com>             2016-06-06 19:26:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2016-06-06 20:43:06 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>              2016-06-06 21:03:29 from Robert Haas <robertmhaas(at)gmail(dot)com>   2016-05-25 18:57:12 from Andres Freund <andres(at)anarazel(dot)de>    2016-05-25 19:02:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-05-25 19:14:25 from Andres Freund <andres(at)anarazel(dot)de>      2016-05-25 19:20:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2016-05-25 20:32:57 from Andres Freund <andres(at)anarazel(dot)de>        2016-05-25 20:55:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-06-03 18:22:56 from Merlin Moncure <mmoncure(at)gmail(dot)com>          2016-06-03 19:52:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-06-03 20:13:37 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>            2016-06-03 20:38:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-08-01 08:23:46 from Andres Freund <andres(at)anarazel(dot)de>          2016-08-02 23:02:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-08-02 23:30:55 from Andres Freund <andres(at)anarazel(dot)de>            2016-08-04 03:22:03 from Andres Freund <andres(at)anarazel(dot)de> 📎             2016-08-18 00:41:28 from Andres Freund <andres(at)anarazel(dot)de>              2016-08-22 18:44:17 from Andres Freund <andres(at)anarazel(dot)de>               2016-08-22 20:20:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2016-08-22 21:43:33 from Andres Freund <andres(at)anarazel(dot)de>                2016-12-08 22:18:30 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2016-12-08 22:42:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2016-08-23 18:55:16 from Andres Freund <andres(at)anarazel(dot)de>               2016-10-03 03:53:26 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>  2016-08-22 21:40:23 from Andres Freund <andres(at)anarazel(dot)de>   2016-08-22 22:02:43 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>   2016-08-27 21:48:29 from Andres Freund <andres(at)anarazel(dot)de> 📎    2016-08-28 03:38:04 from Andres Freund <andres(at)anarazel(dot)de>    2016-08-29 09:56:25 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>     2016-08-29 15:48:56 from Andres Freund <andres(at)anarazel(dot)de>    2016-09-02 08:34:24 from Robert Haas <robertmhaas(at)gmail(dot)com>     2016-09-02 18:16:01 from Andres Freund <andres(at)anarazel(dot)de>    2016-09-12 14:19:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-09-12 16:14:47 from Andres Freund <andres(at)anarazel(dot)de>      2016-09-12 23:56:32 from Andres Freund <andres(at)anarazel(dot)de>       2016-09-12 23:58:06 from Andres Freund <andres(at)anarazel(dot)de> 📎        2016-09-13 00:15:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-09-13 00:32:09 from Andres Freund <andres(at)anarazel(dot)de>    2016-09-12 15:29:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-09-12 16:16:59 from Andres Freund <andres(at)anarazel(dot)de>      2016-09-12 16:25:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2016-09-12 16:10:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-09-12 16:54:03 from Andres Freund <andres(at)anarazel(dot)de>      2016-09-12 17:26:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2016-09-12 17:38:15 from Andres Freund <andres(at)anarazel(dot)de>        2016-09-12 21:36:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-09-12 22:07:05 from Andres Freund <andres(at)anarazel(dot)de>          2016-09-12 22:35:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-09-12 23:11:44 from Andres Freund <andres(at)anarazel(dot)de>            2016-09-12 23:35:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2016-09-12 23:46:30 from Andres Freund <andres(at)anarazel(dot)de>              2016-09-14 23:28:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎               2016-09-15 20:32:22 from Andres Freund <andres(at)anarazel(dot)de>                2016-09-15 20:48:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2016-09-15 21:08:43 from Andres Freund <andres(at)anarazel(dot)de>                  2016-09-15 21:12:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2016-10-03 03:55:35 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>               2016-10-31 16:06:39 from Andres Freund <andres(at)anarazel(dot)de>                2016-10-31 16:25:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2017-01-16 03:29:52 from Andres Freund <andres(at)anarazel(dot)de>                 2017-01-16 08:33:16 from Andres Freund <andres(at)anarazel(dot)de>                  2017-01-16 15:17:46 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                   2017-01-16 18:44:17 from Andres Freund <andres(at)anarazel(dot)de>                    2017-01-16 19:04:34 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                     2017-01-16 21:00:19 from Andres Freund <andres(at)anarazel(dot)de>                      2017-01-16 21:33:30 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                  2017-01-16 19:13:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2017-01-16 20:52:14 from Andres Freund <andres(at)anarazel(dot)de> 📎                    2017-01-17 01:00:39 from Andres Freund <andres(at)anarazel(dot)de> 📎                   2017-01-17 17:05:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2017-01-17 17:52:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2017-01-17 17:58:38 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2017-01-17 18:03:24 from Andres Freund <andres(at)anarazel(dot)de>                      2017-01-17 18:18:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2017-01-17 18:20:52 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2017-01-17 18:43:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2017-01-17 18:53:46 from Andres Freund <andres(at)anarazel(dot)de>                          2017-01-17 19:15:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2017-01-18 13:43:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                            2017-01-18 19:19:24 from Andres Freund <andres(at)anarazel(dot)de>                             2017-01-18 19:24:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                              2017-01-18 19:34:20 from Andres Freund <andres(at)anarazel(dot)de>                               2017-01-18 20:00:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2017-01-18 20:11:47 from Andres Freund <andres(at)anarazel(dot)de>                                 2017-01-18 20:24:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                  2017-01-18 21:47:02 from Andres Freund <andres(at)anarazel(dot)de>                                   2017-01-18 21:56:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2017-01-18 22:11:54 from Andres Freund <andres(at)anarazel(dot)de> 📎                                     2017-01-18 22:34:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2017-01-18 22:58:31 from Andres Freund <andres(at)anarazel(dot)de>                                     2017-01-19 18:06:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                      2017-01-19 22:06:22 from Andres Freund <andres(at)anarazel(dot)de>                                       2017-01-19 23:22:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2017-01-18 23:14:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2017-01-18 23:19:45 from Andres Freund <andres(at)anarazel(dot)de>                                      2017-01-18 23:59:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2017-01-19 00:00:43 from Andres Freund <andres(at)anarazel(dot)de>                                        2017-01-19 00:05:52 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2017-01-19 00:08:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2017-01-18 23:27:53 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                      2017-01-18 23:39:40 from Andres Freund <andres(at)anarazel(dot)de>       2016-09-12 17:44:43 from Andres Freund <andres(at)anarazel(dot)de>        2016-09-12 17:48:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-09-12 17:58:11 from Andres Freund <andres(at)anarazel(dot)de>          2016-09-12 18:05:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-09-12 18:18:11 from Andres Freund <andres(at)anarazel(dot)de>    2016-09-13 16:07:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎     2016-09-13 16:25:05 from Andres Freund <andres(at)anarazel(dot)de>      2016-09-13 17:55:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-09-13 18:03:32 from Andres Freund <andres(at)anarazel(dot)de>      2016-09-13 18:17:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2016-09-15 19:23:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-09-15 19:34:16 from Andres Freund <andres(at)anarazel(dot)de>   2016-09-02 08:31:32 from Robert Haas <robertmhaas(at)gmail(dot)com>    2016-09-02 14:05:35 from Kevin Grittner <kgrittn(at)gmail(dot)com>     2016-09-02 14:11:10 from Andres Freund <andres(at)anarazel(dot)de>      2016-09-02 14:18:38 from Kevin Grittner <kgrittn(at)gmail(dot)com>      2016-09-02 14:20:23 from Andres Freund <andres(at)anarazel(dot)de>       2016-09-02 14:25:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2016-09-02 14:41:28 from Kevin Grittner <kgrittn(at)gmail(dot)com>         2016-09-02 14:51:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2016-09-02 15:01:39 from Kevin Grittner <kgrittn(at)gmail(dot)com>           2016-09-02 15:10:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2016-09-02 16:04:20 from Kevin Grittner <kgrittn(at)gmail(dot)com>            2016-09-02 16:08:02 from Kevin Grittner <kgrittn(at)gmail(dot)com>         2016-09-02 15:31:57 from Andres Freund <andres(at)anarazel(dot)de>          2016-09-02 15:58:59 from Kevin Grittner <kgrittn(at)gmail(dot)com>           2016-09-02 16:25:53 from Andres Freund <andres(at)anarazel(dot)de>            2016-09-02 16:32:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2016-09-02 14:20:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2016-09-02 14:25:16 from Andres Freund <andres(at)anarazel(dot)de>        2016-09-02 14:34:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-09-02 15:29:37 from Andres Freund <andres(at)anarazel(dot)de>    2016-09-02 14:15:47 from Andres Freund <andres(at)anarazel(dot)de>
Lists:	pgsql-hackers

In response to

• Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling) at 2017-01-18 20:11:47 from Andres Freund

Responses

• Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling) at 2017-01-18 21:47:02 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Robert Haas	2017-01-18 20:25:46	Re: Declarative partitioning vs. BulkInsertState
Previous Message	Robert Haas	2017-01-18 20:12:25	Re: Declarative partitioning - another take