On Oct 14, 2008, at 11:36 AM, Bill Thoen wrote:
> The table exists already; all I need to do is update the sequence
> code to make the records unique, but also I need each repeating set
> numbered from 0 (Zero) so I can select a list of unique farm field
> records where seq = 0.
"select distinct on (field_id) * from table;" should let you do that,
without requiring the repeating set stuff.
Cheers,
Steve