Re: BUG #17866: behavior does not match documentation

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: eugeny@zhuzhnev.com, pgsql-bugs <pgsql-bugs@lists.postgresql.org>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Date: 2023-04-10T17:11:31Z
Lists: pgsql-bugs
Daniel Gustafsson <daniel@yesql.se> writes:
> On 23 Mar 2023, at 22:54, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It's more readable for sure, and it duplicates what you got in pre-v14
>> versions, at least textually.  I'm not sure I'd propose back-patching
>> this, but it feels like a good idea for HEAD.

> Agreed, I don't think this is material for backpatching.

Since we didn't get anything done about that for v16, I concluded
that adjusting the docs is a better idea.  If anyone takes this
idea up in v17 or beyond, they can always revert fbbd7edca at that
time.

			regards, tom lane



Commits

  1. Doc: adjust examples of EXTRACT() output to match current reality.

  2. Change return type of EXTRACT to numeric