Re: PostgreSQL Top 10 Wishlist

>
>> 10.
>> Or an alternative to views where tables can be defined with virtual
>> fields which point to functions. So for example I can say:
>> SELECT balance, name FROM customers WHERE balance < 0;
>> ...where balance actually performs a behind the scenes JOIN against a
>> transactions table and totals the customers credits and debits. I
>> realize views can do this but for adding a single dynamic field they
>> are cumbersome and correct me if I'm wrong but I don't think you can
>> UPDATE against a view.
>
> You are wrong, you can make updatable views.

Yes you can but not out of the box. You have to write some rules to make this
go, isn't it ?

Aly.

--
Aly S.P Dharshi
aly(dot)dharshi(at)telus(dot)net

"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"