We are using PostgreSQL as a reporting database. Domains calculated columns allows some of PostgreSQL functions but doesn't allow case statement, if conditions etc. sometimes it requires condition based calculated column using multiple tables but we forced to create new derived table for a single column which leads to increasing number of derived tables. it will be helpful if calculated columns have some flexibility of writing elementary database procedural language.
Anil Kumar Madan
| Components | Domains |
