Re: Update table with max occurance from another table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Winslow" <d(dot)winslow(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update table with max occurance from another table
Date: 2002-11-19 19:42:36
Message-ID: 22583.1037734956@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dan Winslow" <d(dot)winslow(at)cox(dot)net> writes:
> Yes, I tried this, but it doesn't like the order or the limit clause in
> sub-selects.

Then you need a newer version of Postgres; that's been supported since
7.1.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Winslow 2002-11-19 19:53:26 Re: Update table with max occurance from another table
Previous Message Dan Winslow 2002-11-19 19:40:14 Re: Update table with max occurance from another table