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.dharshi@telus.net

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