Re: suggest about bpchar data type in the document

2022-09-28 Thread Tom Lane
Laurenz Albe writes: >> I think that adding "bpchar(n)" in table 8.4 would be a good thing. > Here is a patch for that. There would need to be some mention of it in the paras below, too. regards, tom lane

Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely

2022-09-28 Thread Bruce Momjian
On Tue, Aug 16, 2022 at 03:32:36PM -0400, Bruce Momjian wrote: > On Sat, Dec 25, 2021 at 02:36:27PM +, Erki Eessaar wrote: > > > > Hello > > > > PostgreSQL 14 added the feature: "Allow SQL-language functions and > > procedures > > to use SQL-standard function bodies." > > > > If I

Re: suggest about bpchar data type in the document

2022-09-28 Thread Laurenz Albe
On Wed, 2022-09-28 at 10:48 -0400, Tom Lane wrote: > Laurenz Albe writes: > > > I think that adding "bpchar(n)" in table 8.4 would be a good thing. > > > Here is a patch for that. > > There would need to be some mention of it in the paras below, too. True. I think the attached should be

Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely

2022-09-28 Thread Bruce Momjian
On Sun, Sep 11, 2022 at 09:46:47PM -0700, Noah Misch wrote: > On Thu, Sep 08, 2022 at 01:20:31PM +0200, Peter Eisentraut wrote: > > On 01.09.22 03:11, Bruce Momjian wrote: > > >On Tue, Aug 16, 2022 at 03:38:13PM -0400, Bruce Momjian wrote: > > >>On Tue, Aug 16, 2022 at 03:34:22PM -0400, Tom Lane

Re: Developer FAQ Dead Link

2022-09-28 Thread Bruce Momjian
On Thu, Sep 8, 2022 at 11:33:01PM +0800, found not wrote: > Hi, I find some links in Developer FAQ "Where can I get a copy of the SQL > standards" Section are dead. > * SQL:1999 http://web.cs.ualberta.ca/~yuan/courses/db_readings/ > ansi-iso-9075-2-1999.pdf (This link is 404 now) > *

Re: suggest about bpchar data type in the document

2022-09-28 Thread Tom Lane
Laurenz Albe writes: > On Wed, 2022-09-28 at 10:48 -0400, Tom Lane wrote: >> There would need to be some mention of it in the paras below, too. > True. I think the attached should be sufficient. Pushed. I failed to resist the temptation to do some further cleanup in the same area.

Re: suggest about bpchar data type in the document

2022-09-28 Thread Laurenz Albe
On Wed, 2022-09-28 at 12:32 -0400, Tom Lane wrote: > Laurenz Albe writes: > > On Wed, 2022-09-28 at 10:48 -0400, Tom Lane wrote: > > > There would need to be some mention of it in the paras below, too. > > > True.  I think the attached should be sufficient. > > Pushed.  I failed to resist the

Re: suggest about bpchar data type in the document

2022-09-28 Thread Laurenz Albe
On Wed, 2022-09-14 at 18:48 +0200, Laurenz Albe wrote: > On Wed, 2022-09-14 at 17:41 +0800, yanliang lei wrote: > > I hope that: > > > >  in the  https://www.postgresql.org/docs/14/datatype-characterin.html ,It > > needs to be written clearly  “bpchar” data type, > > > > and in the above url,