Re: [GENERAL] Re: Order question

[Tom Lane]

"Mitch Vincent" <[EMAIL PROTECTED]> 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