Update Ordering Using Non-Indexed Fields - Mailing list pgsql-novice

From Benjamin Hurt
Subject Update Ordering Using Non-Indexed Fields
Date
Msg-id 1336776716.98079.YahooMailClassic@web160501.mail.bf1.yahoo.com
Whole thread Raw
List pgsql-novice
I have a table foo (d,f,mj,mn) where (d,f) is the primary unique key and the only index. I've added a new sequence and
anew integer column v and would like to insert into v using this new sequence but using the sort order of (mj,mn)
insteadof (d,f), which is how it's working if I do a simple "update foo set v = nextval('inc')". What's the best way to
accomplishthis ?  

pgsql-novice by date:

Previous
From: Jayadevan M
Date:
Subject: Re: I am NOT a programmer!
Next
From: Daniel Staal
Date:
Subject: Text search language field