I suppose you could use the oid column as long as it was not wrapping
(starting to count over).
Joseph
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Mitch Vincent
> Sent: Tuesday, February 13, 2001 6:24 PM
> To: Mike Castle; pgsql-general@postgresql.org
> Subject: [GENERAL] Re: Re: Order question
>
>
> Sure, I was just wondering if there was some PG internal value I could use
> (and I should have said that in my email)..
>
> Thanks for the suggestion though, I appreciate it..
>
> -Mitch
>
> ----- Original Message -----
> From: "Mike Castle" <dalgoda@ix.netcom.com>
> To: <pgsql-general@postgresql.org>
> Sent: Tuesday, February 13, 2001 6:18 PM
> Subject: Re: Re: Order question
>
>
> > 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 clock: You can work constantly
> > dalgoda@ix.netcom.com and be right all the time, or not work at all
> > www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
> > We are all of us living in the shadow of Manhattan. -- Watchmen
> >
>