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
