Re: repost(gmane): sql update max smartries

From: Vic Cekvenich <vin(at)friendVU(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: repost(gmane): sql update max smartries
Date: 2004-10-22 00:33:40
Message-ID: 41785564.8000400@friendVU.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>>
>
>

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-22 00:44:58 Re: correct example of a functional index usage?
Previous Message Carlo Florendo 2004-10-22 00:31:43 Re: inquiry on readline functionality on psql client