viewing the original order of entered records

From: "Sven Van Acker" <Sven(dot)Van(dot)Acker(at)vub(dot)ac(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Subject: viewing the original order of entered records
Date: 2003-06-10 08:27:43
Message-ID: 000601c32f2a$2d71a3e0$4441b886@starpc18
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I've the following problem:

I have a 2-column table with columns "person_id"(int4) and "phase"(text).

When I entered the following records in a chronological fashion: <1, "high
school">; <1, "childhood"> and <2, "university">;

I requested the following select-statement.

SELECT person_id, phase FROM life ORDER BY person_id

And found the tuple <1, "childhood"> before the tuple <1, "high school">.

I want to view the chronological order of my entries, but ordered by
person_id.

Is this possible in postgresql?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sven Van Acker 2003-06-10 09:50:11 viewing the original (chrnological) order of entered records
Previous Message Richard Huxton 2003-06-10 07:28:23 Re: 2 servers with 1 database cluster