Ilja Booij <[EMAIL PROTECTED]> said:
> 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.
My goal is to make sure that whatever schema we use for DBMail's
address-catchalls and domain-catchalls can easily be used with
Postfix/MySQL for pre-delivery address checking. No need to use LIMIT in
DBMail itself.
Aaron
--
