Horton
Menu

Re: PostgreSQL 16 release announcement draft

jian he <jian.universality@gmail.com>

View thread
From: jian he <jian.universality@gmail.com>
To: "Jonathan S. Katz" <jkatz@postgresql.org>
Cc: David Rowley <dgrowleyml@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, chelseadole@gmail.com
Date: 2023-08-24T15:16:55Z
Lists: pgsql-hackers 
hi. Can you check my first email about "a" versus "the" and "pg_stat_activity".

also:
"including the `\bind` command, which allows
users to execute parameterized queries (e.g `SELECT $1 + $2`) then use `\bind`
to substitute the variables."

The example actually is very hard to reproduce. (it's not that super intuitive).
fail case:
test16-# SELECT $1 + $2 \bind 1 2
test16-# ;

a better example would  be (e.g `SELECT $1 , $2`).
The semicolon still needed to be in the next line.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Support "Right Anti Join" plan shapes.

  2. Improve performance of ORDER BY / DISTINCT aggregates