On Mon, Apr 21, 2008 at 10:34 AM, Colin Wetherbee <cww@xxxxxxxxxxxxxxxx> wrote: > I would like to have a table that contains a connection for each distinct > pair of points (point1 to point2 is the same as point2 to point1). This > table would then be automatically updated every time a modification is made > to the reference table. If my calculation is correct, the new table would > contain 3,654,456 rows using the current data set. > > I realize I could use a TRIGGER to keep the connections table fresh, and > perhaps that's also a solution. > > But, really, I'm just wondering if PostgreSQL has some automated, built-in > facility for situations like this? Would a functional index do this for you? Perhaps, you wouldn't even need a table is you store these computed values in an index instead. -- Regards, Richard Broersma Jr.
