repost(gmane): sql update max smartries - Mailing list pgsql-general

From Vic Cekvenich
Subject repost(gmane): sql update max smartries
Date
Msg-id cl9i5q$cut$1@sea.gmane.org
Whole thread Raw
List pgsql-general
I am trying to write a sigle command to update the max number from detail.

>
> Something like:
> update group set max_msgid=max(c.msgid)
>     from group g, content c
>     where g.id=c.g_id
>
> So group is master, content is detail. I want group to stroe
> max(msgid) from content.
>
> Syntax help plz?
> .V
>

pgsql-general by date:

Previous
From: Vic Cekvenich
Date:
Subject: sql update max smartries
Next
From: "Davide Negri"
Date:
Subject: Question on the 8.0Beta Version