Re: Updating column to link one table to another - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Updating column to link one table to another
Date
Msg-id 41C697B8.9030700@archonet.com
Whole thread Raw
In response to Updating column to link one table to another  (Mark Collette <mark@hyperbyte.ab.ca>)
List pgsql-sql
Mark Collette wrote:
> 
> Now, I've added the infrequentId columns to both, as an optimization, so 
> that I can quickly find the InfrequentTable entry for a given 
> FrequentTable entry.  I've done this because I want to speed up 
> SELECTs.  Any new INSERTs are working just fine.  But, all my legacy 
> entries, are not linked up yet.  I need to know how I can UPDATE the 
> FrequentTable rows, where their infrequentId is zero, to point at the 
> last InfrequentTable entry whose timestamp ts is before its own 
> timestamp ts.

How do you distinguish between InfrequentTable entries when their 
timestamp is the same?

--  Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Kretschmer Andreas
Date:
Subject: Re: Question about geometric function area()
Next
From: Doug Y
Date:
Subject: I'm stumped