I am trying to write a sigle command to update the max number from detail.
[color=blue]
>
> 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
>[/color]
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[color=blue]
>
> 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
>[/color]
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend