Re: PL/pgSQL casing

pá 2. 9. 2022 v 11:38 odesílatel Daniel Gustafsson napsal: > There are a few instances of PL/PgSQL in the docs, the attached changes the > casing on those to PL/pgSQL which we use consistently otherwise. > +1 Pavel > -- > Daniel Gustafsson https://vmware.com/ > >

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

ne 28. 8. 2022 v 18:36 odesílatel jian he napsal: > > > On Sun, Aug 28, 2022 at 4:07 PM Pavel Stehule > wrote: > >> >> >> ne 28. 8. 2022 v 12:36 odesílatel Pavel Stehule >> napsal: >> >>> Hi >>> >>> >>> ne 28. 8.

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

ne 28. 8. 2022 v 12:36 odesílatel Pavel Stehule napsal: > Hi > > > ne 28. 8. 2022 v 10:10 odesílatel jian he > napsal: > >> >> Equivalent C Types for Built-in SQL Types >> https://www.postgresql.org/docs/15/xfunc-c.html#XFUNC-C-TYPE-TABLE >> Does postgr

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

Hi ne 28. 8. 2022 v 10:10 odesílatel jian he napsal: > > Equivalent C Types for Built-in SQL Types > https://www.postgresql.org/docs/15/xfunc-c.html#XFUNC-C-TYPE-TABLE > Does postgres have Equivalent C range Type for Built-in SQL range Types? > > No, there is only common ancestor - RangeType

Re: Array functions, array_length behavior given an empty array

po 8. 11. 2021 v 18:11 odesílatel David G. Johnston < david.g.johns...@gmail.com> napsal: > On Monday, November 8, 2021, Pavel Stehule > wrote: > >> Hi >> >> po 8. 11. 2021 v 13:48 odesílatel PG Doc comments form < >> nore...@postgresql.org> napsal: &

Re: Array functions, array_length behavior given an empty array

to be mentioned in the description and/or in > examples. > you can read related discussion https://pgsql-hackers.postgresql.narkive.com/lZJQ64dp/array-length-anyarray Use instead function cardinality Regards Pavel Stehule > > With best regards, > Oleg Rekin >

Re: getting table name from partition

Hi pá 30. 7. 2021 v 0:24 odesílatel Bruce Momjian napsal: > On Wed, Jul 14, 2021 at 01:45:12PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/13/ddl-partitioning.html > > Description: > > >

Re: pl/pgsql errors when multi-dimensional arrays are used

Hi čt 29. 4. 2021 v 12:33 odesílatel Rafal Dabrowa napsal: > This also returns ERROR: invalid input syntax for type integer: > "[221,222,223,224]" > > On 4/29/2021 9:48 AM, KraSer wrote: > > try: > > a.fld1[1] = '[221,222,223,224]'; > > > > чт, 29 апр. 2021 г. в 10:35, PG Doc comments form > >

Re: INNER JOIN syntax is not commonly used?

ne 7. 3. 2021 v 12:45 odesílatel Vik Fearing napsal: > On 3/7/21 10:33 AM, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/13/tutorial-join.html > > Description: > > > > This page shows a WHERE synta

Re: Change JOIN tutorial to focus more on explicit joins

pá 23. 10. 2020 v 11:14 odesílatel Jürgen Purtz napsal: > On 22.10.20 17:14, Pavel Stehule wrote: > > > > Why do you use parenthesis for ON clause? It is useless. SQL is not C > > or JAVA. > > > Two more general answers: > - Why do people use tabs, spaces, and n

Re: Change JOIN tutorial to focus more on explicit joins

čt 22. 10. 2020 v 18:27 odesílatel David G. Johnston < david.g.johns...@gmail.com> napsal: > On Thu, Oct 22, 2020 at 8:14 AM Pavel Stehule > wrote: > >> Why do you use parenthesis for ON clause? It is useless. SQL is not C or >> JAVA. >> >> > At th

Re: Change JOIN tutorial to focus more on explicit joins

čt 22. 10. 2020 v 15:32 odesílatel Jürgen Purtz napsal: > On 22.10.20 01:40, David G. Johnston wrote: > > On Fri, Sep 4, 2020 at 2:36 AM Jürgen Purtz wrote: > >> On 04.09.20 08:52, Peter Eisentraut wrote: >> > >> > For the remaining patch I have a couple of concerns: >> > > This patch should not

Re: Wrong parameter names for make_interval (Postgres 13)

po 5. 10. 2020 v 18:48 odesílatel Pavel Stehule napsal: > > > po 5. 10. 2020 v 17:53 odesílatel Tom Lane napsal: > >> Pavel Stehule writes: >> > po 5. 10. 2020 v 15:56 odesílatel Thomas Kellerer >> napsal: >> >> So instead of >> >> m

Re: Wrong parameter names for make_interval (Postgres 13)

po 5. 10. 2020 v 17:53 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > po 5. 10. 2020 v 15:56 odesílatel Thomas Kellerer > napsal: > >> So instead of > >> make_interval ( [ year int [, month int [, week int [, day int [, hour > >>

Re: Wrong parameter names for make_interval (Postgres 13)

po 5. 10. 2020 v 15:56 odesílatel Thomas Kellerer napsal: > There is a typo in the parameter names of the make_interval() function. > > The parameter names are all defined with plural, not singular as it is > shown > in the Postgres 13 manual. > > So instead of > > make_interval ( [ year int

Re: Version 13 documentation layout is harder to read than version 12

út 29. 9. 2020 v 16:32 odesílatel Pavel Stehule napsal: > > > út 29. 9. 2020 v 16:29 odesílatel Tom Lane napsal: > >> Pavel Stehule writes: >> > the new layout is probably better, but I miss some gentle separation of >> > these three parts - maybe using a di

Re: Version 13 documentation layout is harder to read than version 12

út 29. 9. 2020 v 16:29 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > the new layout is probably better, but I miss some gentle separation of > > these three parts - maybe using a different font? > > Hm? If you mean synopsis vs. description vs. examples, the descr

Re: Version 13 documentation layout is harder to read than version 12

út 29. 9. 2020 v 15:52 odesílatel Tom Lane napsal: > PG Doc comments form writes: > > Compare: > > * https://www.postgresql.org/docs/13/functions-json.html > > * https://www.postgresql.org/docs/12/functions-json.html > > > I know it is just my opinion, but the version 12 layout is easier to read

Re: Procedures

po 24. 8. 2020 v 18:00 odesílatel Bruce Momjian napsal: > On Mon, Aug 24, 2020 at 05:51:29PM +0200, Pavel Stehule wrote: > > sure. Maybe enhancing about sentence like "it is not possible in a > function." > > > > and > > > > "a procedure can com

Re: Procedures

po 24. 8. 2020 v 17:38 odesílatel Bruce Momjian napsal: > On Mon, Aug 24, 2020 at 11:35:57AM -0400, Bruce Momjian wrote: > > On Mon, Aug 24, 2020 at 05:24:19PM +0200, Pavel Stehule wrote: > > > > > > > > > po 24. 8. 2020 v 17:01 odesílatel Bruce Momjian >

Re: Procedures

po 24. 8. 2020 v 17:01 odesílatel Bruce Momjian napsal: > On Sat, Aug 22, 2020 at 01:21:43PM -0700, David G. Johnston wrote: > > On Sat, Aug 22, 2020 at 10:14 AM Bruce Momjian wrote: > > > > On Fri, Aug 21, 2020 at 07:42:35PM -0700, David G. Johnston wrote: > > > > > [...] the CALL comma

Re: docs: psql and variable interpolation

po 13. 7. 2020 v 15:09 odesílatel Philippe Beaudoin < philippe.beaud...@dalibo.com> napsal: > Hi all, > > I recently used the nice variable capabilities in psql, after having read > the "SQL Interpolation" chapter in the psql page ( > https://www.postgresql.org/docs/12/app-psql.html). > > But I sp

Re: explanation for random_page_cost is outdated

ne 26. 4. 2020 v 21:25 odesílatel yigong hu napsal: > Sorry to hijack the thread, I also recently have similar observation that > the statement about random_page_cost on SSD is ambiguous. The current > document says that > > > Storage that has a low random read cost relative to sequential, e.g. >

Re: Example 42.4. A PL/pgSQL Trigger Function for Auditing

Dne po 16. 12. 2019 20:28 uživatel Tom Lane napsal: > Pavel Stehule writes: > > po 16. 12. 2019 v 12:12 odesílatel PG Doc comments form < > > nore...@postgresql.org> napsal: > >> I'm wondering if it would be worthwhile to put a totally generic > auditing &g

Re: Example 42.4. A PL/pgSQL Trigger Function for Auditing

po 16. 12. 2019 v 12:12 odesílatel PG Doc comments form < nore...@postgresql.org> napsal: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/plpgsql-trigger.html > Description: > > I'm wondering if it would be worthwhile to put a tota

Re: Proposed HTML Documentation Styles

čt 4. 10. 2018 v 17:50 odesílatel Jonathan S. Katz napsal: > Hi, > > As part of the effort to modernize the look and feel of PostgreSQL.org > and associated web projects, Sarah & I have worked on applying the new > styles to the documentation. The main goals of the project were: > > - To have the