Full Outer Join with dates as index? - Mailing list pgsql-novice

Hi,

I need to do something like a full outer join on two tables that contain dates and prices that were observed on these
dates(call them the prices of apples and oranges), but I want only one column of dates. On some days, the price of
applesis observed but the price of oranges is not observed, and vice versa. The tables look something like this: 

price_of_oranges:
date        price_of_oranges
1999-1-1    3.45
1999-1-3    4.65

price_of_apples:
date        price_of_apples
1999-1-2    5.87

What I want is a table that looks like this:
date        price_of_oranges        price_of_apples
1999-1-1    3.45                NULL
1999-1-2    NULL                5.87
1999-1-3    5.87                NULL

What's the easiest way to do this?

Thanks.

Max