Re: problem with select after updating

SQL doesn't specify how updates/inserts etc. will affect ordering of rows in
a table. If you need a specific ordering of results, you always must use
ORDER BY. There is no guarantee of ordering otherwise.

Bob


On Monday 10 December 2001 11:07 am, Raul DAVIDOVICH wrote:
> Hello,
>
>      I'm having a problem when updating a row.. after comiting the change,
> the row appears at the end of the list, and from there on, it stays there
> until the next update.
>      This happens when using both JDBC or psql. Normally, rows shouldn't
> change the order after updates. Am I messing it up with the indexes?
>
> thank you very much in advance
>
> ---------------------------------------------------
> Raul Davidovich
> Responsable Informatique
> Cvitkovic & Associés Consultants
>
> (33) 1 45 15 40 68
> (33) 1 45 15 40 41 Fax
> -------------------------------------------------------
> http://www.caconcology.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org