DEV Community

Discussion on: Using Materialized Views as Models in Lucky

Collapse
 
buinauskas profile image
Evaldas Buinauskas

You're allowed to have union in material views in Postgres?!

Collapse
 
mikeeus profile image
Mikias Abera

Hi Evaldas, I hope you enjoyed the article. You can actually create whatever kind of query you want. A materialized view is just a query whose resulting rows are persisted as if it was a normal table.

Collapse
 
buinauskas profile image
Evaldas Buinauskas

I did. I'm just used to SQL Server materialized views implementation. It has way more restrictions. That's why I was surprised 😊

Thread Thread
 
mikeeus profile image
Mikias Abera

Interesting, I've never used SQL server. tbh I've used Postgresql ever since I learned to code and I've never had a reason to try anything eles