Re: SEARCH and CYCLE clauses

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: Vik Fearing <vik@postgresfriends.org>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2021-02-22T08:44:30Z

Lists: pgsql-hackers

Attachments

0001-Enhanced-cycle-mark-values.patch (text/plain) patch 0001

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.  Here is a patch 
for it.

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