Postgres Pro
Downloads
Home   >   mailing lists

Thread: Model clause and

Model clause and

From
SQL Padawan
Date:

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



Re: Model clause and

From
SQL Padawan
Date:

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 Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, October 28th, 2021 at 20:57, SQL Padawan <sql_padawan@protonmail.com> wrote:

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




Re: Model clause and

From
Michael Lewis
Date:
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?


Is this not what you want?

Re: Model clause and

From
Thomas Kellerer
Date:
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.

Re: Model clause and

From
Michael Lewis
Date:
Mea culpa.

"PostgreSQL currently implements only stored generated columns."

I should re-read what I share references to rather than trust my memory, particularly while sick. Thanks for kindly correcting.