To get on top of this thread again (literally ;-), I'm just exploring
options for maintaining interoperability with Postfix's MySQL address
table lookup. As long as we can write a query that will emulate enough of
DBMail's behaviour to generate a result that correctly accepts/rejects
addresses, then we're fine.
Aaron
Micah <[EMAIL PROTECTED]> said:
> Now that I'm looking at it, doesn't DBMail want to deliver to ALL the aliases
> that match in the table? So we wouldn't want limit anyhow, right?
>
> -Micah
>
> On Wednesday 20 October 2004 01:26 am, Ilja Booij wrote:
>> On Tue, 19 Oct 2004 16:07:18 -0700, Micah <[EMAIL PROTECTED]> wrote:
>> > How about this, as concat seems to be in both MySQL and PG:
>> >
>> > SELECT * from dbmail_aliases WHERE 'delivery_address' LIKE concat('%',
>> > alias, '%') limit 1;
>>
>> LIMIT is a bit nasty. It's not SQL92, only in MySQL and PGSQL. I'm not
>> in favour of using it in queries in DBMail.
>>
>> Ilja
>> _______________________________________________
