Re: repost(gmane): sql update max smartries

#1

Vic Cekvenich wrote:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: repost(gmane): sql update max smartries

comp.databases.postgresql.general comp.databases.postgresql.general

Re: repost(gmane): sql update max smartries - 10-21-2004 , 07:33 PM