"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 B
Mitch Vincent wrote:
>
> A further extension of this..
>
> What might I be able to additionally order by so that the most recently
> updated rows get ordered above everything else (within the order by
> ordernum).. Using the same example :
>
> > ordernum | fieldname | oid
> > --+
On Tue, Feb 13, 2001 at 05:58:35PM -0500, Mitch Vincent wrote:
> 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?
make a trigger that updates a time stamp and order by that?
mrc
--
Mike Castle Life is like a
A further extension of this..
What might I be able to additionally order by so that the most recently
updated rows get ordered above everything else (within the order by
ordernum).. Using the same example :
> ordernum | fieldname | oid
> --+---+-
> 1 |
