populating a field automatically

Hello all,

I am trying to populate a field in a table by looking up values from
another table. Here are my (simplified tables):

CREATE TABLE small(
id char(14),
addr int4,
street char(15),
city char(15),
other text,
infor text,
mation text
);

CREATE TABLE big(
id char(14),
addr int4,
street char(15),
city char(15),
other text,
stuff text
);

I am trying to populate id in table small by looking up the
corresponding addr, street and city in table big. I am trying to
avoid a JOIN because table big is very large, and table small will not
change once it is constructed (lookups only). If I populate id into
table small, I can then use a simple, fast query on table small
directly.

My question is, then, how to popluate id in table small without
running each query by hand and inserting the result myself. Should I
try to use an insert trigger? I see that pl/pgsql can loop over all
the rows of a table. Is this kind of a function the way to go? Any
thoughts or suggestions would be appreciated.

--
Larry Holish
<ljholish(at)speakeasy(dot)net>