| Add XMLCanonicalize function |
4237 |
Moved to different CF |
SQL Commands
|
19 |
9/10
|
+509−0
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), Oliver Ford (ojford), Yogesh Sharma (sharmay), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
16 |
1 month ago |
| Incremental View Maintenance (IVM), take 2 |
4337 |
Moved to different CF |
SQL Commands
|
|
Needs rebase!
|
|
Yugo Nagata (yugo.nagata) |
Alexandre Felipe (afelipe) |
|
16 |
2 days ago |
| Implement row pattern recognition feature |
4460 |
Moved to different CF |
SQL Commands
|
19 |
9/10
|
+46915−45
|
Tatsuo Ishii (ishii), Henson Choi (assam258.gmail.com) |
Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033), Henson Choi (assam258.gmail.com) |
|
15 |
19 hours ago |
| Make COPY format extendable: Extract COPY TO format implementations |
4681 |
Moved to different CF |
SQL Commands
|
|
Needs rebase!
|
|
Kouhei Sutou (kou) |
Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli) |
|
11 |
1 month ago |
| COPY TO json |
4716 |
Committed |
SQL Commands
|
|
10/10
|
+620−65
|
Joe Conway (jconway) |
Masahiko Sawada (masahikosawada), Richard Yen (richyen) |
Andrew Dunstan (adunstan) |
10 |
2 months ago |
| SQL Property Graph Queries (SQL/PGQ) |
4904 |
Committed |
SQL Commands
|
|
Needs rebase!
|
|
Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) |
Vik Fearing (xocolatl), Zhao Junwang (zhjwpku), Hannu Krosing (hannukrosing), Henson Choi (assam258.gmail.com) |
Peter Eisentraut (petere) |
10 |
1 month ago |
| Add OR REPLACE option to CREATE MATERIALIZED VIEW |
5099 |
Moved to different CF |
SQL Commands
|
|
9/10
|
+694−98
|
Erik Wienhold (ewie) |
Paul Jungwirth (pjungwir), newtglobal postgresql_contributors (newtpostgrescontributors), Soumya S Murali (soumyamurali) |
|
9 |
3 weeks ago |
| Add XMLCast (SQL/XML X025) |
5110 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+2746−26
|
Jim Jones (jimus) |
Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
11 |
1 month ago |
| SQL:2023 JSON simplified accessor support |
5214 |
Returned with feedback |
SQL Commands
|
19 |
Needs rebase!
|
|
Alexandra Wang (alexandrawang) |
Peter Eisentraut (petere), Vik Fearing (xocolatl), Jelte Fennema-Nio (jeltef), Chao Li (chaol) |
|
9 |
1 month ago |
| jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
5270 |
Committed |
SQL Commands
|
|
Needs rebase!
|
|
Florents Tselai (florentst) |
David Wheeler (theory) |
Andrew Dunstan (adunstan) |
5 |
1 month ago |
| Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) |
5279 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+1559−59
|
Jim Jones (jimus) |
newtglobal postgresql_contributors (newtpostgrescontributors) |
|
9 |
1 month ago |
| Add XMLDocument (SQL/XML X030) |
5431 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+258−1
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
8 |
1 month ago |
| Add XMLNamespaces option to XMLElement |
5456 |
Moved to different CF |
SQL Commands
|
19 |
9/10
|
+1242−41
|
Pavel Stehule (okbobcz), Jim Jones (jimus) |
Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
8 |
1 month ago |
| SQL:2011 Application Time Update & Delete |
5836 |
Committed |
SQL Commands
|
19 |
Needs rebase!
|
|
Paul Jungwirth (pjungwir) |
Peter Eisentraut (petere) |
Peter Eisentraut (petere) |
5 |
1 month ago |
| Allow ON CONFLICT DO SELECT/UPDATE to return EXCLUDED values |
5854 |
Moved to different CF |
SQL Commands
|
19 |
Needs rebase!
|
|
Dean Rasheed (deanr) |
Viktor Holmberg (rutchkiwi) |
|
6 |
3 months ago |
| CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions |
5941 |
Moved to different CF |
SQL Commands
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
Corey Huinker (coreyh) |
|
5 |
1 month ago |
| CREATE SCHEMA ... CREATE DOMAIN support |
5985 |
Committed |
SQL Commands
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
Tom Lane (tgl) |
Tom Lane (tgl) |
4 |
1 month ago |
| CREATE TABLE LIKE INCLUDING TRIGGERS |
6087 |
Moved to different CF |
SQL Commands
|
19 |
9/10
|
+0−0
|
Jian He (stayreal) |
Andrey Borodin (x4m), Henson Choi (assam258.gmail.com), Zsolt Parragi (zsolt.parragi) |
|
4 |
2 weeks ago |
| create table like including storage parameter |
6088 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+218−9
|
Jian He (stayreal) |
lakshmi g (lakshmi) |
|
4 |
3 weeks ago |
| ON CONFLICT DO SELECT |
6109 |
Committed |
SQL Commands
|
19 |
10/10
|
+1677−367
|
Viktor Holmberg (rutchkiwi) |
Dean Rasheed (deanr), Jian He (stayreal) |
Dean Rasheed (deanr) |
3 |
3 months ago |
| COPY FROM with RLS |
6178 |
Moved to different CF |
SQL Commands
|
19 |
9/10
|
+275−63
|
Jian He (stayreal) |
|
|
4 |
2 weeks ago |
| ago(interval) → timestamptz |
6202 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+25−0
|
Florents Tselai (florentst) |
|
|
3 |
6 months ago |
| implement GRANT/REVOKE ... GRANTED BY |
6218 |
Committed |
SQL Commands
|
19 |
10/10
|
+145−34
|
Tom Lane (tgl), Nathan Bossart (bossartn) |
Jaime Casanova (jcasanov), Adam Brusselback (tostino) |
Nathan Bossart (bossartn) |
2 |
2 months ago |
| Add support for partial incremental materialized view refresh using REFRESH ... WHERE |
6305 |
Moved to different CF |
My First Patch
SQL Commands
|
19 |
10/10
|
+1468−70
|
Adam Brusselback (tostino) |
Dharin Shah (dharins0) |
|
3 |
3 days ago |
| Cleaning up PREPARE query strings? |
6341 |
Moved to different CF |
SQL Commands
|
|
10/10
|
+135−23
|
Julien Rouhaud (rjuju) |
Sami Imseih (simseih) |
|
3 |
2 months ago |
| Create unique GiST index |
6368 |
Moved to different CF |
Bugfix
SQL Commands
|
19 |
0/10
|
+447−17
|
Paul Jungwirth (pjungwir) |
warda bibi (warda), Prafulla Ranadive (pprandive) |
|
3 |
2 months ago |
| Add SQL/JSON ON MISMATCH clause to JSON_VALUE, JSON_QUERY, JSON_TABLE |
6429 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+747−52
|
Florents Tselai (florentst) |
|
|
2 |
3 months ago |
| Add `tsmatch` JSONPath operator for granular Full Text Search |
6436 |
Moved to different CF |
SQL Commands
|
19 |
10/10
|
+597−4
|
Florents Tselai (florentst) |
Chao Li (chaol) |
|
2 |
1 month ago |
| Add CREATE SCHEMA ... LIKE support |
6481 |
Returned with feedback |
DDL
SQL Commands
|
|
0/10
|
+1462−10
|
Matheus Alcantara (matheus.alcantara) |
|
|
1 |
3 months ago |
| Optional skipping of unchanged relations during ANALYZE? |
6516 |
Moved to different CF |
psql
Performance
SQL Commands
|
19 |
Needs rebase!
|
|
Vasu M (vasu01) |
Ilia Evdokimov (ilidock95) |
|
2 |
2 months ago |
| tid_blockno() and tid_offset() accessor functions |
6559 |
Committed |
SQL Commands
|
|
10/10
|
+198−0
|
Ayush Tiwari (aytiwari) |
|
Andres Freund (andresfreund) |
2 |
1 month ago |