| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Vik Fearing <vik(at)postgresfriends(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SEARCH and CYCLE clauses |
| Date: | 2020-06-15 09:49:53 |
| Message-ID: | 1a7fbf28-7bca-501e-3cbb-04e6776e1716@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Here is an updated patch that I think fixes all the cases that you
identified. (The issue of what kinds of constants or expressions to
accept for cycle marks has not been touched.) To fix the star expansion
I had to add a little bit of infrastructure that could also be used as a
more general facility "don't include this column in star expansion", so
this could perhaps use some consideration from a more general angle as well.
More tests and breakage reports welcome.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-SEARCH-and-CYCLE-clauses.patch | text/plain | 82.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey V. Lepikhov | 2020-06-15 09:59:18 | Re: Asynchronous Append on postgres_fdw nodes. |
| Previous Message | Dean Rasheed | 2020-06-15 09:13:24 | Re: Infinities in type numeric |