Re: number of queries in mysql

On Tue, Jun 07, 2005 at 08:53:38PM +0200, cami wrote:

> Gustavo A. Baratto wrote:
> >
> >Cami wrote:
> >
> >>Gustavo A. Baratto wrote:
> >>
> >>man 5 mysql_table. Postfix allows freeform queries that should
> >>resolve your problems (if i'm wrong, someone mention it).
> >>
> >>query = SELECT destination FROM alias WHERE alias='%u@%d'
> >
> >Still wondering why the %s key is different than %u@%d though...
> > what I understood from the doc is that:
> >
> > %u@%d = %s
>
> Someone will have to check me on this one:
>
> %s is replaced by the input key. If you do not specify
> exactly what it is you're after, Postfix will specify
> multiple keys to lookup, hence why you have multiple
> queries occurring by default.
>

This is explained in mysql_table(5), ldap_table(5) and pgsql_table(5).

--
Viktor.

Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the "Reply-To" header.

To unsubscribe from the postfix-users list, visit
http://www.postfix.org/lists.html or click the link below:
<mailto:majordomo@postfix.org?body=unsubscribe%20p ostfix-users>