Re: Updating record drops it to the bottom

--On Tuesday, November 26, 2002 07:16:42 -0800 "Aurangzeb M. Agha"
<aagha(at)bigfoot(dot)com> wrote:

> I've noticed that whenever I update a record in the table and do a select
> * to see my change, that the updated racord has dropped to the bottom of
> the table.
>
> Is there either a) a (simple) way to keep this from happening or b)
> putting the record back where it "belongs" after an update.
>
> The reason is is annoying me is that one of our internal apps has onld
> piece of JS which builds sub menus on a form based on the (DB driven)
> order of the parent menu. Yes, yes... the solution is to fix the JS, but
> until the JS guy gets back, the DB solution is what comes to mind.
There is no order defined by SQL. If you want a particular order, add an
ORDER BY
to the SQL.

>
> Thx in advance,
> Aurangzeb
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749