On 10/6/23 20:49, PG Doc comments form wrote:
>
I'm left not really understanding how to use _ in numerical constants?
You are reading the documentation for 16, but you are using 14 or lower.
If you want this functionality, you need to upgrade your server.
--
Vik Fearing
On 10/6/23 11:57, Peter Eisentraut wrote:
On 26.09.23 17:31, Vik Fearing wrote:
For example, we do not have the JSON_SERIALIZE(), JSON()[1],
JSON_SCALAR() functions. We don't have the IS JSON predicate, or a
few other things hiding behind T801.
AFAICT, commit 03734a7fed, which is n
standard intends, and therefore we should not claim to support T801.
[1] This is a fully specified parsing function, not just a cast like we
have today.
--
Vik Fearing
The current docs can be read as using DISTINCT in an aggregate
(count(distinct col)) and ORDER BY (array_agg(col ORDER BY col)) are
both extensions to the standard.
The actual truth is that our extension to the standard is to allow both
at the same time.
Attached is a trivial patch to make t
te.
> We have integer GUCs and float8 GUCs, but no numeric GUCs.
> I do not see a useful purpose in obscuring that distinction.
>
> I could see using a couple more words than I suggested before:
>
> work_mem (integer, units of kilobytes)
This gets a little more complicated with:
shared_buffers (integer, units of BLOCKSZ)
--
Vik Fearing
ER JOIN syntax is not as common as
> WHERE syntax.
> Is this really the case?
I don't remember the last time I saw a new query use the syntax. In my experience, the syntax is
much more common. I vote to change the wording on that page.
--
Vik Fearing
On 09/01/2020 16:19, Peter Eisentraut wrote:
> On 2020-01-03 11:00, Magnus Hagander wrote:
>> On 2019-12-30 00:03, Vik Fearing wrote:
>> > Following a complaint on IRC about the dearth of information on
>> how to
>> > migrate to a new major
>
>
> I think "even" means "equality" here, not "even" of "even and odd".
It does actually mean "even and odd". This kind of rounding is also
called "Banker's Rounding".
https://en.wikipedia.org/wiki/Rounding#Round_half_to_even
--
Vik Fearing
P was trying to upgrade to v10), and I didn't see any
place to put it for 13 and future versions.
--
Vik Fearing
diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml
index dfa3851913..62cdbba2d5 100644
--- a/doc/src/sgml/release-12.sgml
+++ b/doc/src/sgml/release-12.sgml
On 26/11/2018 15:14, Tom Lane wrote:
> Michael Paquier writes:
>> On Mon, Nov 26, 2018 at 08:17:06AM +0100, Vik Fearing wrote:
>>> On 26/11/2018 08:03, Magnus Hagander wrote:
>>>> Are you sure that's right? To me the original wording of that sentence
>>>
tion.
> -
>
>
>
> Are you sure that's right? To me the original wording of that sentence
> seems to convey the message properly, and the update done does not?
Yeah, I just found this on the committers list and I disagree with the
change as well.
--
Vik Fear
it's just one
process doing the insert, you won't notice any performance drop at all.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
I have added an entry in the commit
> fest app so as this is not lost:
> https://commitfest.postgresql.org/16/1387/
I approve of this change.
Ready for Committer.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
13 matches
Mail list logo