Re: Default ordering option

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Cyril Champier <cyril(dot)champier(at)doctolib(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Default ordering option
Date: 2019-07-25 10:21:54
Message-ID: bfefa5ba-ca12-6d94-647d-37d4cb22f99b@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2019-07-25 09:43, Cyril Champier wrote:
> It might be an interesting exercise to implement this as a post-parsing
> hook.
>
>  
> I known nothing about that, but that sounds interesting, do you have any
> documentation pointer to help me implement that?

Look for post_parse_analyze_hook. Walk the parsed query tree, look for
queries without ordering clause and manufacture one.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cyril Champier 2019-07-25 11:12:09 Re: Default ordering option
Previous Message Alban Hertroys 2019-07-25 08:39:15 Re: Request for resolution || Support