Re: Recursive CTE for building menus - Mailing list pgsql-general

From Tim Smith
Subject Re: Recursive CTE for building menus
Date
Msg-id CA+HuS5HxjtCM4jy2bJeE14e3X57188YLwjLJc__FMdsmTwAV3Q@mail.gmail.com
Whole thread Raw
In response to Re: Recursive CTE for building menus  (Paul Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-general
On 13 April 2018 at 16:04, Paul Jungwirth <pj@illuminatedcomputing.com> wrote:
> On 04/13/2018 02:09 AM, Bob Jones wrote:
>>
>> The adaptions I am trying to make are as follows:
>> - Higher priority moves the item higher up the menu (i.e. adapting
>> from the original "votes" concept).
>> - Default alphabetical ordering of titles
>> - Use of alphanumeric IDs instead of numeric
>
>
> Hi, I wrote that blog post! :-)
><snip>

Accidentally hit the wrong reply button and sent a reply direct to
Paul instead of list.

I won't repeat my message here, but instead I will just leave a brief
expression of public gratitude to the great man himself for taking the
time to reply.

For the record: A quick simple test indicates (as might be expected)
that the proposed query works.

Thanks again.

Bob


pgsql-general by date:

Previous
From: Jonathan Morgan
Date:
Subject: how to securely delete the storage freed when a table is dropped?
Next
From: Jerry Sievers
Date:
Subject: Gratuitous use of savepoint considered silly, if not harmful