viewing the original (chrnological) order of entered records - Mailing list 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?