Model clause and
Good evening everybody.
Are there any plans to emulate Oracle MODEL clause in PostgreSQL?
If not, why not? It doesn't appear to have gained much traction even in the Oracle world?
Also, are there any plans to introduce the MATCH_RECOGNIZE functionality?
I read an interview with Dimitri and he said he'd really like to see this in Postgres?
I presume that VIRTUAL GENERATED columns are on the to-do list?
Just curious.
SQLP
That's Dimitri Fontaine - I don't know him personally and didn't mean to be impolite by referring to him by his first name - typo really!
SQLP
Sent with [ProtonMail](https://protonmail.com/) Secure Email.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, October 28th, 2021 at 20:57, SQL Padawan <sql_padawan@protonmail.com> wrote:
Show quoted text
Good evening everybody.
Are there any plans to emulate Oracle MODEL clause in PostgreSQL?
If not, why not? It doesn't appear to have gained much traction even in the Oracle world?
Also, are there any plans to introduce the MATCH_RECOGNIZE functionality?
I read an interview with Dimitri and he said he'd really like to see this in Postgres?
I presume that VIRTUAL GENERATED columns are on the to-do list?
Just curious.
SQLP
On Thu, Oct 28, 2021 at 1:57 PM SQL Padawan <sql_padawan@protonmail.com>
wrote:
I presume that VIRTUAL GENERATED columns are on the to-do list?
https://www.postgresql.org/docs/current/ddl-generated-columns.html
Is this not what you want?
Michael Lewis schrieb am 28.10.2021 um 22:44:
On Thu, Oct 28, 2021 at 1:57 PM SQL Padawan <sql_padawan@protonmail.com <mailto:sql_padawan@protonmail.com>> wrote:
I presume that VIRTUAL GENERATED columns are on the to-do list?
https://www.postgresql.org/docs/current/ddl-generated-columns.html
Is this not what you want?
Those are persisted/stored generated columns. They are only evalated
when a row is inserted or updated.
Virtual generated columns are evaluated each time you access, so they
could use volatile functions.