On Wed, Oct 21, 2009 at 07:17:44PM -0700, semi-ambivalent wrote: > If I have a table with fields A, B, C and D how could I do something > such that if I insert values in fields A, B and C field D would be > auto-filled with the value A||B||C? Just a pointer of where to begin > looking is fine. Triggers? Copy ... From? Table or field > definitions?
Instead of populating your table with this extra information, create a VIEW with what you want in it. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
