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

From Vic Cekvenich
Subject Re: repost(gmane): sql update max smartries
Date
Msg-id 41785564.8000400@friendVU.com
Whole thread Raw
List pgsql-general
Vic Cekvenich wrote:

> 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: Carlo Florendo
Date:
Subject: Re: inquiry on readline functionality on psql client
Next
From: Tom Lane
Date:
Subject: Re: correct example of a functional index usage?