Re: SEARCH and CYCLE clauses

Vik Fearing <vik@postgresfriends.org>

From: Vik Fearing <vik@postgresfriends.org>

To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2021-02-22T10:05:09Z

Lists: pgsql-hackers

Attachments

sql_features.diff (text/x-patch) patch

On 2/22/21 9:44 AM, Peter Eisentraut wrote:
> On 22.05.20 14:32, Peter Eisentraut wrote:
>>> As an improvement over the spec, I think the vast majority of people
>>> will be using simple true/false values.  Can we make that optional?
>>>
>>>      CYCLE f, t SET is_cycle USING path
>>>
>>> would be the same as
>>>
>>>      CYCLE f, t SET is_cycle TO true DEFAULT false USING path
>>
>> I was also considering that.  It would be an easy change to make.
> 
> This change has been accepted into the SQL:202x draft.

Yay!

> Here is a patch for it.

This looks good to me, except that you forgot to add the feature stamp.
 Attached is a small diff to apply on top of your patch to fix that.
-- 
Vik Fearing

Commits

Enhanced cycle mark values
- f4adc41c4f92 14.0 landed
SEARCH and CYCLE clauses
- 3696a600e229 14.0 landed
doc: Expand recursive query documentation
- 323ae003e464 14.0 landed
Adjust cycle detection examples and tests
- 3fb676504da9 14.0 landed