Re: Consequence of changes to CTE's in 12

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Consequence of changes to CTE's in 12
Date: 2021-02-12 00:23:45
Message-ID: CAHOFxGqFevsCeo1pRRB3+EYsNWfiEwUHWU5HU-OktH0P-2muJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This functionality seems more a candidate for a set-returning function
rather than a view, but I like my views to be side effect free and read
only. It would be trivial to implement in plpgsql I believe.

If you move the limit 1 to the first CTE, does it not give you the same
behavior in both versions?

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-02-12 00:23:46 Re: Consequence of changes to CTE's in 12
Previous Message Steve Baldwin 2021-02-12 00:06:41 Consequence of changes to CTE's in 12