viewing the original order of entered records

Поиск
Список
Период
Сортировка
От Sven Van Acker
Тема viewing the original order of entered records
Дата
Msg-id 000601c32f2a$2d71a3e0$4441b886@starpc18
обсуждение исходный текст
Ответы Re: viewing the original order of entered records  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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?

 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Kallol Nandi"
Дата:
Сообщение: DBCS
Следующее
От: "Roderick A. Anderson"
Дата:
Сообщение: Schemas