Postgres Pro
Downloads
Home   >   mailing lists

Re: Update table with max occurance from another table - Mailing list pgsql-general

From Tom Lane
Subject Re: Update table with max occurance from another table
Date
Msg-id 22583.1037734956@sss.pgh.pa.us
Whole thread Raw
In response to Re: Update table with max occurance from another table  ("Dan Winslow" <d.winslow@cox.net>)
List pgsql-general
Tree view 
"Dan Winslow" <d.winslow@cox.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

pgsql-general by date:

Previous
From: "Dan Winslow"
Date:
Subject: Re: Update table with max occurance from another table
Next
From: "Dan Winslow"
Date:
Subject: Re: Update table with max occurance from another table