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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
