"Mitch Vincent" <mitch(at)venux(dot)net> writes:
> I just set the row with j.inv_id to 1, I'd like it to be ordered above the
> row with j.jobtitle in it -- is that possible?
Not unless you add a field with an update sequence number, or some such,
and then explicitly use that field as a second ORDER BY key. The system
does not maintain anything like that for you --- and should not, IMHO,
since it'd be useless overhead for apps that didn't care.
regards, tom lane