Re: Add support for data change delta tables

2024-01-16 Thread Jim Nasby
On 1/15/24 4:40 AM, Pavel Stehule wrote: PostgreSQL is not a project where somebody says, you will do this, and you will do this, in this and this priority. There are a lot of nice features from standard - SQL standard is big, but a) you have to have funds to pay the developers, b) you have to

Re: Add support for data change delta tables

2024-01-15 Thread Adrian Klaver
On 1/15/24 02:44, Thomas Kellerer wrote: PavelTurk schrieb am 15.01.2024 um 11:00: Currently PostgreSQL doesn't support data change delta tables. For example, it  doesn't support this type of query: SELECT * FROM NEW TABLE ( INSERT INTO phone_book VALUES ( 'Peter Doe', '555-2323' ) ) 

Re: Add support for data change delta tables

2024-01-15 Thread Thomas Kellerer
PavelTurk schrieb am 15.01.2024 um 11:00: > Currently PostgreSQL doesn't support data change delta tables. For example,  > it doesn't support this type of query: > > SELECT * FROM NEW TABLE ( > INSERT INTO phone_book > VALUES ( 'Peter Doe', '555-2323' ) > ) AS t > > PostgreSQL has RETURNI

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
po 15. 1. 2024 v 11:27 odesílatel PavelTurk napsal: > > On 1/15/24 12:17 PM, Pavel Stehule wrote: > > > > po 15. 1. 2024 v 11:11 odesílatel PavelTurk > napsal: > >> >> On 1/15/24 12:05 PM, Pavel Stehule wrote: >> >> Hi >> >> po 15. 1. 2024 v 11:00 odesílatel PavelTurk >> napsal: >> >>> Hello al

Re: Add support for data change delta tables

2024-01-15 Thread PavelTurk
On 1/15/24 12:17 PM, Pavel Stehule wrote: po 15. 1. 2024 v 11:11 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal: On 1/15/24 12:05 PM, Pavel Stehule wrote: Hi po 15. 1. 2024 v 11:00 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal: Hello all,

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
po 15. 1. 2024 v 11:11 odesílatel PavelTurk napsal: > > On 1/15/24 12:05 PM, Pavel Stehule wrote: > > Hi > > po 15. 1. 2024 v 11:00 odesílatel PavelTurk > napsal: > >> Hello all, >> >> >> Currently PostgreSQL doesn't support data change delta tables. For example, >> it doesn't support this type

Re: Add support for data change delta tables

2024-01-15 Thread PavelTurk
On 1/15/24 12:05 PM, Pavel Stehule wrote: Hi po 15. 1. 2024 v 11:00 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal: Hello all, Currently PostgreSQL doesn't support data change delta tables. For example,  it doesn't support this type of query: SELECT * FROM NEW TABLE

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
Hi po 15. 1. 2024 v 11:00 odesílatel PavelTurk napsal: > Hello all, > > > Currently PostgreSQL doesn't support data change delta tables. For example, > it doesn't support this type of query: > > SELECT * FROM NEW TABLE ( > INSERT INTO phone_book > VALUES ( 'Peter Doe', '555-2323' ) >