Re: Update Help on PREPARE to mention DEALLOCATE

On Tue, Apr 16, 2024 at 4:42 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Apr 16, 2024 at 1:27 PM Kirk Wolak wrote: > >> Could we make the PREPARE line read >> ... >> > No. That is a syntax excerpt and the prepare command doesn't accept

Update Help on PREPARE to mention DEALLOCATE

Please notice this exchange: 16:20:02 devuser@nctest= # \h deallocate Command: DEALLOCATE Description: deallocate a prepared statement Syntax: DEALLOCATE [ PREPARE ] { name | ALL } URL: https://www.postgresql.org/docs/16/sql-deallocate.html 16:20:11 devuser@nctest= # \h PREPARE Command:

Re: pass open cursor via USING in execute staement

On Thu, Jun 1, 2023 at 9:32 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/plpgsql-statements.html > Description: > > Should be documented if this statement is allowed or not (if not, maybe set >

Re: Remove obsolete mention of backslashes as escapes

On Tue, Apr 11, 2023 at 3:54 AM Laurenz Albe wrote: > The documentation in > > https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING > says that > > "While the standard syntax for specifying string constants is usually > convenient, > it can be difficult to

Re: February 9th, 2023 Release links to a missing page

On Sun, Feb 19, 2023 at 4:55 PM Jonathan S. Katz wrote: > On 2/19/23 3:55 PM, Kirk Wolak wrote: > > On Wed, Feb 15, 2023 at 2:05 PM Jonathan S. Katz > <mailto:jk...@postgresql.org>> wrote: > > > > The release announcements go through the news system, which

Re: February 9th, 2023 Release links to a missing page

On Wed, Feb 15, 2023 at 2:05 PM Jonathan S. Katz wrote: > On 2/15/23 1:59 PM, Kirk Wolak wrote: > > It looks like a simple bad reference name: > > > > On this line: > > > > * Fix the |psql| > > <https://www.postgresql.org/docs/current/app-

February 9th, 2023 Release links to a missing page

It looks like a simple bad reference name: On this line: - Fix the psql commands \sf and \ef to handle SQL-language functions that have SQL-standard function bodies

Re: nextval parameter is not clear

On Thu, Dec 1, 2022 at 4:21 PM Laurenz Albe wrote: > On Tue, 2022-11-29 at 16:26 -0500, Kirk Wolak wrote: > > On Mon, Nov 28, 2022 at 12:45 AM Tom Lane wrote: > > > Laurenz Albe writes: > > > > Now I think that is taking it too far. Your code sample would be

Re: Tutorial book with runable code for Postgres?

On Tue, Nov 29, 2022 at 5:16 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Nov 29, 2022 at 2:42 PM Kirk Wolak wrote: > >> On Tue, Nov 29, 2022 at 3:40 AM Matous Jan Fialka wrote: >> >>> Hello. >>> >>> I would like to ge

Re: Tutorial book with runable code for Postgres?

On Tue, Nov 29, 2022 at 3:40 AM Matous Jan Fialka wrote: > Hello. > > I would like to get some opinion on a petite idea I got while reading > the "nextval > parameter is not clear" thread. Because it may not fit well to the > thread itself > I managed to create a new one instead... > > +1 (right

Re: nextval parameter is not clear

On Mon, Nov 28, 2022 at 12:45 AM Tom Lane wrote: > Laurenz Albe writes: > > Now I think that is taking it too far. Your code sample would be great > > for a tutorial, but it is too elaborate for the technical documentation. > > The example should focus on the sequence functions, but more than

Re: nextval parameter is not clear

On Mon, Nov 28, 2022 at 12:47 PM Tom Lane wrote: > Kirk Wolak writes: > > my goal is to get an "approach" accepted, this is the first. > Ultimately, I > > would love to see > > the documentation of functions with examples like this everywhere. > > I'm not

Re: nextval parameter is not clear

On Sun, Nov 27, 2022 at 10:34 PM Laurenz Albe wrote: > On Sat, 2022-11-26 at 23:22 -0500, Kirk Wolak wrote: > > Your feedback would be appreciated. > > + Example > > I think you should use the tag to render that more conspicuous. > > I tried. it does n

Re: nextval parameter is not clear

On Mon, Nov 28, 2022 at 12:45 AM Tom Lane wrote: > Laurenz Albe writes: > > Now I think that is taking it too far. Your code sample would be great > > for a tutorial, but it is too elaborate for the technical documentation. > > The example should focus on the sequence functions, but more than

Re: nextval parameter is not clear

On Fri, Nov 25, 2022 at 10:06 PM Kirk Wolak wrote: > On Fri, Nov 25, 2022 at 9:58 AM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Fri, Nov 25, 2022 at 12:40 AM Laurenz Albe >> wrote: >> >>> On Thu, 2022-11-24 at 15:50 -0500,

Re: nextval parameter is not clear

On Fri, Nov 25, 2022 at 9:58 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Nov 25, 2022 at 12:40 AM Laurenz Albe > wrote: > >> On Thu, 2022-11-24 at 15:50 -0500, Kirk Wolak wrote: >> > >> > David, let me see how that looks. From

Re: nextval parameter is not clear

On Fri, Nov 25, 2022 at 9:58 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Nov 25, 2022 at 12:40 AM Laurenz Albe > wrote: > >> On Thu, 2022-11-24 at 15:50 -0500, Kirk Wolak wrote: >> > >> > David, let me see how that looks. From

Re: nextval parameter is not clear

On Thu, Nov 24, 2022 at 10:44 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Nov 24, 2022 at 7:33 AM Kirk Wolak wrote: > >> On Thu, Nov 24, 2022 at 5:33 AM Laurenz Albe >> wrote: >> >>> On Thu, 2022-11-24 at 02:41 -0500, Kir

Re: nextval parameter is not clear

On Thu, Nov 24, 2022 at 5:33 AM Laurenz Albe wrote: > On Thu, 2022-11-24 at 02:41 -0500, Kirk Wolak wrote: > > Alright, as I have the documentation build working, and a slightly > better stylesheet, > > the comments on the last block were not aligned. > > They are fixe

Re: nextval parameter is not clear

On Thu, Nov 24, 2022 at 2:04 AM Kirk Wolak wrote: > On Wed, Nov 23, 2022 at 11:06 PM Kirk Wolak wrote: > >> On Tue, Nov 22, 2022 at 11:43 PM David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >>> On Tue, Nov 22, 2022 at 8:42 PM Kirk Wolak wrot

Re: nextval parameter is not clear

On Wed, Nov 23, 2022 at 11:06 PM Kirk Wolak wrote: > On Tue, Nov 22, 2022 at 11:43 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Tue, Nov 22, 2022 at 8:42 PM Kirk Wolak wrote: >> >>> >>> .. >> The wiki is an e

Re: nextval parameter is not clear

On Tue, Nov 22, 2022 at 11:43 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Nov 22, 2022 at 8:42 PM Kirk Wolak wrote: > >> >> >> On Tue, Nov 22, 2022 at 2:10 PM Bruce Momjian wrote: >> >>> On Tue, Oct 18, 2022 at

Re: nextval parameter is not clear

On Tue, Nov 22, 2022 at 2:10 PM Bruce Momjian wrote: > On Tue, Oct 18, 2022 at 08:17:12AM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/14/functions-sequence.html > > Description: > > > >