Re: JSONB operator unanticipated behaviour

2023-05-18 Thread Brian Mendoza
tainment match, and duplicate array elements are effectively considered only once." and was expecting array equality to be the comparison. Good to know! Many thanks On Thu, 18 May 2023 at 15:41, Adrian Klaver wrote: > On 5/18/23 06:17, Brian Mendoza wrote: > > Hello, >

JSONB operator unanticipated behaviour

2023-05-18 Thread Brian Mendoza
? -- f (1 row) So the keys are the same, the values (when compared directly) are not, but @> returns True. Have I misunderstood the usage of the operator? The above queries have been run on postgres 14, if that helps. -- Brian Mendoza br...@rotamap.net Rotamap www.rotamap.net 020 7631 1555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928