Re: BUG #18589: pg_get_viewdef returns wrong query - Mailing list pgsql-bugs

On Tue, Aug 27, 2024 at 4:46 PM Richard Guo <guofenglinux@gmail.com> wrote:
> From my brief 2-minute look at how special_exprkind is used, it seems
> that special_exprkind is either EXPR_KIND_GROUP_BY or EXPR_KIND_NONE.
> Since it doesn't seem to be extensible as expected, I agree that maybe
> a bool field is more straightforward.  Then we can have another bool
> field for ORDER BY, avoiding the need to override the in-group-by
> setting.

Alternatively, can we set special_exprkind = EXPR_KIND_ORDER_BY in
get_rule_orderby?  I’m looking for a approach that is parallel to how
we set special_exprkind = EXPR_KIND_GROUP_BY in get_basic_select_query.

Thanks
Richard