MIME-Version: 1.0
References: <CACX+KaN-Lqv+k6d4b37oKFiqF6ibMkq1RVHbcTby5EjRtNQewg@mail.gmail.com>
 <CAKFQuwbMkum2q05EvhVNWXC4ij-HL-Nv=3d5yDPfZsEhNTrJbQ@mail.gmail.com> <CACX+KaMxg+WiHuQHA8==BmP0jsVFXm-RKnAd1bhF=yFYopP4Pg@mail.gmail.com>
In-Reply-To: <CACX+KaMxg+WiHuQHA8==BmP0jsVFXm-RKnAd1bhF=yFYopP4Pg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 7 Apr 2024 10:01:18 -0700
Message-ID: <CAKFQuwaMN7LkHwqm9LHxpR2_PdN_NGMyrmvL_VshV+=hxiBkrQ@mail.gmail.com>
Subject: Re: Clarification on View Privileges and Operator Execution in PostgreSQL
To: Ayush Vatsa <ayushvatsa1810@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000070e434061584a573"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaMN7LkHwqm9LHxpR2_PdN_NGMyrmvL_VshV%2B%3DhxiBkrQ%40mail.gmail.com>
Precedence: bulk

--00000000000070e434061584a573
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Apr 7, 2024 at 9:32=E2=80=AFAM Ayush Vatsa <ayushvatsa1810@gmail.co=
m> wrote:

>  but who will execute the
> > underlying function inside the ( > ) operator ? Is it postgres or alex?
>
>>
I'm reasonably confident that all the built-in functions are security
invoker.  Not that a pure function like greater-than really cares.

David J.

--00000000000070e434061584a573
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sun, Apr 7, 2024 at 9:32=E2=80=AFAM Ayush Vatsa &lt;<a =
href=3D"mailto:ayushvatsa1810@gmail.com">ayushvatsa1810@gmail.com</a>&gt; w=
rote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div>=C2=A0=
but who will execute the=C2=A0<br></div><div><div>&gt; underlying function =
inside the ( &gt; ) operator ? Is it postgres or alex?</div></div></div></d=
iv><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><div><div style=3D"font-fa=
mily:arial,helvetica,sans-serif"></div></div></div></div></blockquote></div=
></blockquote><div>=C2=A0</div><div><div class=3D"gmail_default" style=3D"f=
ont-family:arial,helvetica,sans-serif">I&#39;m reasonably confident that al=
l the built-in functions are security invoker.=C2=A0 Not that a pure functi=
on like greater-than really cares.</div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">David J.</div><br>=
</div></div></div>

--00000000000070e434061584a573--