Re: computed field on a table

Peter Eisentraut wrote:

>David Garamond wrote:
>
>
>>This is a feature of Interbase/Firebird. Is this planned for future
>>version of Postgres (I can always use a view for this though).
>>
>>
>
>
>
I would use a view which would keep the amount of accesses to the table
low as well.

J

>Use a trigger to keep a materialized version of the computed field up to
>date, or use a view to compute the field dynamically. No other
>mechanisms are planned.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL