| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Camila Rocha <camilarrocha(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Rows ordered |
| Date: | 2002-10-04 14:54:31 |
| Message-ID: | 20021004145431.GD2326@atentus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 03, 2002 at 05:34:29AM -0700, Camila Rocha wrote:
> I have another problem: I want to keep the rows in a table ordered. Is
> there some structure in postgresql that can help me??
You should be using ORDER BY in your SELECT's if you want any ordering.
That said, the CLUSTER command can be used to order the rows physically
within the table following some index. Read its documentation before
using it, it can be dangerous to your schema!!
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La victoria es para quien se atreve a estar solo"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-04 14:57:13 | Re: Trouble compiling postgresql in hp-unix |
| Previous Message | Alvaro Herrera | 2002-10-04 14:52:37 | Re: Inheritance: problems with primary key |