Re: SQL problem: bank account

From: "Andrew J(dot) Kopciuch" <akopciuch(at)bddf(dot)ca>
To: "Erik G(dot) Burrows" <eburrows(at)erikburrows(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL problem: bank account
Date: 2003-06-02 06:13:39
Message-ID: 200306020013.39200.akopciuch@bddf.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> I need to get the most recent transaction for each customer. I need only
> the transaction ID, but the entire row would be best.
>

Why don't you alter the customer table to hold the transaction ID of the most
recent transaction?

Some questions though:

Do you vacuum the database regularly?
Do you have any indexes created?

Some things to think about.

Andy

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sean Chittenden 2003-06-02 06:21:37 Re: SQL problem: bank account
Previous Message Erik G. Burrows 2003-06-02 05:30:15 SQL problem: bank account