postgresql timestamp

[Anon]

I'm using postgresql 7.2. For one of the fields in one of my tables, i'm inserting a timestamp. How do I retrieve the row with the smallest timestamp? I don't want to have a large resultset and then filter it because this will take too long. Or is this the only way?

Thanx 🙂

[Anon]

select * from t where timestampcolumn in (select min(timestamcolumn) from t)