Horton
Menu

Re: PostgreSQL 16 release announcement draft

Chapman Flack <chap@anastigmatix.net>

View thread
From: Chapman Flack <chap@anastigmatix.net>
To: "Jonathan S. Katz" <jkatz@postgresql.org>
Cc: jian he <jian.universality@gmail.com>, David Rowley <dgrowleyml@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, chelseadole@gmail.com
Date: 2023-08-24T15:38:05Z
Lists: pgsql-hackers 
On 2023-08-24 11:23, Jonathan S. Katz wrote:
> 
> SELECT $1::int + $2::int \bind 1 2 \g

One cast also works, letting type inference figure out the other.
So if I say

SELECT $1::int + $2 \gdesc

it tells me the result will be int. That made me wonder if there is
a \gdesc variant to issue the "statement variant" Describe message
and show what the parameter types have been inferred to be. If
there's not, obviously it won't be in 16, but it might be useful.

Regards,
-Chap

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