>
> > It seems like the only advantage of that preferential ordering is for
> the
> > snmp counter, as the 'rid' return value from that query is not used
> > anywhere else, and the other 4 return values are all from the msgs table
> > (static for multiple recipients).. Unless I'm missing something
Riaan,
> > It is correct as it stands. It is not a condition, it is an expresion.
> > ORDER BY expression [ ASC | DESC | USING operator ] [, ...]
> > The rid=? compares the rid from a field with a recipient id
> > we have in the message under test, returning true or false.
> > The ORDER BY rid=?
On 01/06/07, Mark Martinec <[EMAIL PROTECTED]> wrote:
>
> Riaan,
>
> > (line 910 in V2.5.1 of amavisd)
> > 'sel_penpals_msgid' => # with a nonempty message-id references list
> > "SELECT msgs.time_num, msgs.mail_id, subject, message_id, rid".
> > " FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcp
Riaan,
> (line 910 in V2.5.1 of amavisd)
> 'sel_penpals_msgid' => # with a nonempty message-id references list
> "SELECT msgs.time_num, msgs.mail_id, subject, message_id, rid".
> " FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id".
> " WHERE sid=? AND content!='V' AND ds='P' AND messa
Hi there,
I'm thinking of doing the penpal thing, but, just to check, is this right?:
(line 910 in V2.5.1 of amavisd)
'sel_penpals_msgid' => # with a nonempty message-id references list
"SELECT msgs.time_num, msgs.mail_id, subject, message_id, rid".
" FROM msgs JOIN msgrcpt ON msgs.mail_id=m
