src / test / regress / sql / triggers.sql first 10 lines.

1 -- 2

Re: json_object returning jsonb reuslt different from returning json, returning text

EYS RETURNING jsonb) FROM (VALUES (1, 1), (0, NULL),(4, null), (5, null),(6, null),(2, 2)) foo(k, v); return {"0": null, "1": 1, "2": 2} On Mon, Apr 25, 2022 at 10:41 AM alias wrote: > select json_objectagg( > k:v absent on null with unique keys returni

json_object returning jsonb reuslt different from returning json, returning text

select json_objectagg( k:v absent on null with unique keys returning text ) from ( values(1,1),(0, null),(3, null),(2,2),(4,null) ) foo(k, v); return json_objectagg -- { "1" : 1, "2" : 2 } select json_objectagg(k:v absent on null with unique

Allow specifying column list for foreign key ON DELETE SET src_test_regress_sql_foreign_key.sql don't understand the comment.

git.postgresql.org Git - postgresql.git/commit git.postgresql.org Git - postgresql.git/blob - src/test/regress/expected/foreign_key.out

Re: aggregate array broken in postgresql 15.

my mistake. I don't know that aggregate can also overload. problem solved On Thu, Apr 7, 2022 at 4:09 PM Pavel Stehule wrote: > Hi > > čt 7. 4. 2022 v 12:30 odesílatel alias napsal: > >> >> https://github.com/postgres/postgres/commit/97f73a978fc1aca59c6ad7

aggregate array broken in postgresql 15.

https://github.com/postgres/postgres/commit/97f73a978fc1aca59c6ad765548ce0096d95a923?diff=split https://dbfiddle.uk/?rdbms=postgres_14&fiddle=11a30590cb376a24df172198139d758e select version(); version --