From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: computed field on a table |
Date: | 2004-01-18 20:29:32 |
Message-ID: | 400AECAC.8020004@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2004-01-18 20:34:20 | Re: Using a Makefile during database development |
Previous Message | Carlos Costa Portela | 2004-01-18 19:51:14 | Great change (size of data dir) upgrading postgresql |