Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

The first part I’m saying is a bad example because you wouldn’t store the price + vat in a column let alone a calculated column.

The second part I’m giving an example where doing:

where created + period > now() - '3 days'::interval

Having to calculate the value in a where clause is inefficient.

Making a calculated column adding created and period then indexing it is more efficient.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: