How to Select a Tupl by Nearest Date - Mailing list pgsql-sql

Hello

Assume I have a table like
create table foo (id serial,date foodate,primary key(id)
);

with 2 tuplsinsert into foo(foodate) values('2008-07-07');  --id = 1insert into foo(foodate) values('2008-07-04'); --
id= 2
 

What I need is to select the nearest tupl by a given date and I do not know how to do this.

Something like:
select id from foo where foo date = nearest('2008-07-06');-> should return 1

select id from foo where foo date = nearest('2008-07-05');-> should return 2

How can I do this? Note: I have a large Table (> 5'000'000 rows) so a good performing way would be a welcome asset :)

Thanks
Christian
-- 
GMX Kostenlose Spiele: Einfach online spielen und Spaß haben mit Pastry Passion!
http://games.entertainment.gmx.net/de/entertainment/games/free/puzzle/6169196