Re: IN for records

2023-07-19 Thread Tom Lane
Ilya Nenashev writes: > I totally agree. > Who and when will put these changes into the documentation pages? Done at https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=15c68cd84a2c80eed9b67ed6746ed5b91baea587 regards, tom lane

Re: IN for records

2023-07-19 Thread Ilya Nenashev
described as a > > expression for scalars, and as a shorthand notation for a combination of > > operators || and = > > > In section #COMPOSITE-TYPE-COMPARISON described extension, to use > operators > > with a records, like "record operator record" for uncertai

Re: IN for records

2023-07-18 Thread Tom Lane
PG Doc comments form writes: > In section #FUNCTIONS-COMPARISONS-IN-SCALAR operator IN is described as a > expression for scalars, and as a shorthand notation for a combination of > operators || and = > In section #COMPOSITE-TYPE-COMPARISON described extension, to use operators >

IN for records

2023-07-18 Thread PG Doc comments form
of operators || and = In section #COMPOSITE-TYPE-COMPARISON described extension, to use operators with a records, like "record operator record" for uncertain set of operators, and noted "Composite type comparisons are allowed when the operator is =, <>, <, <=, > or >=

Duplicating Records When Inserting

2019-10-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/release-11-5.html Description: Hello, when starting to use postgres version 11.5, there are duplicate records, what can it be? I have always used 9.6 and never had this problem. I'm