On Tue, Oct 13, 2009 at 9:59 AM, Michael Schwipps <msc(dot)listen(at)online(dot)de>wrote:
> Hi,
>
> I want to select the last contact of person via mail.
> My sample database is build with the following shell-commands
>
> | createdb -U postgres test2
> | psql -U postgres test2 < mail_db.sql
> | mailtest.sh | psql -U postgres
>
> I call to get the answer
>
> | SELECT address, max(sent) from mail inner join
> | tomail on (mail.id=tomail.mail) group by address;
>
> you are missing vacuumdb -z test2
after mailtest.sh ..
--
GJ