Hello list,
After update a column on a table, that row goes to the top when I do a
select from that table without any order, is that the expected behavior
in postgresql? is there a way to prevent it?
Thanks in advance.
Josué Maldonado
---(end of broadcast)---
Clinging to sanity, [EMAIL PROTECTED] (Josué Maldonado) mumbled into her beard:
> After update a column on a table, that row goes to the top when I do a
> select from that table without any order, is that the expected
> behavior in postgresql? is there a way to prevent it?
Prevent what?
SQL retur
On Tue, Mar 02, 2004 at 04:12:05PM -0600, Josué Maldonado wrote:
> After update a column on a table, that row goes to the top when I do a
> select from that table without any order, is that the expected behavior
> in postgresql?
Yes.
> is there a way to prevent it?
No. Use ORDER BY.
--
Alv
My understanding of RDBMs:
you will get all information as indicated by the query in an unsorted order.
Sometimes you get the same order; sometimes you do not.
To ensure expected ordering you must use the ORDER keyword.
Quoting Josué Maldonado <[EMAIL PROTECTED]>:
> Hello list,
>
> After
