Andrew Guts wrote:

>update catalogue
> set last_location =
> (select location from transfers x where x.catalog_id = catalogue.id
>and x.id =
> (select max(id) from transfers cx where cx.catalog_id = x.catalog_id))
>
>
>

By the way it's a surprise:

"Error: multiple rows in singleton select"

So "max()" could return multiple rows?. How nice.

Andrew