proposal - reglanguage type

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal - reglanguage type
Date: 2020-03-01 10:07:56
Message-ID: CAFj8pRCWNEcd3LtJuYZ=wyGOSTRe3KEcdJ40XY3QcxYrhp65eQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I miss a reglanguage type from our set of reg* types.

It reduce a mental overhead for queries over pg_proc table

With this type I can easy filter only plpgsql functions

select *
from pg_proc
where prolang = 'plpgsql'::reglanguage
and pronamespace <> 'pg_catalog'::regnamespace;

Regards

Pavel

Attachment Content-Type Size
reglanguage.patch text/x-patch 14.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Darafei Komяpa Praliaskouski 2020-03-01 10:09:22 Re: Yet another fast GiST build
Previous Message Andres Freund 2020-03-01 08:46:38 Re: Improving connection scalability: GetSnapshotData()