No, that makes sense, because the alias value of 'postmaster' exists within the deliver to address of '[EMAIL PROTECTED]'. So this does make sense to me at least. :)
Once again, although it's nice to make things feature rich with stuff like Regular expressions, I think it would be too hard to make cross platform for everyone. Once again I have no idea about compatibility for PG, or Oracle for that matter. I just did a test: SELECT * from dbmail_aliases where '[EMAIL PROTECTED]' LIKE alias works if you did the global alias like this: [EMAIL PROTECTED] -Micah On Tuesday 19 October 2004 03:15 pm, Aaron Stone wrote: > I'm a doofus: I was using the 'REGEX' keyword. Which doesn't exist. REGEXP > works fine, except that the results don't seem to make sense... > > mysql> select alias,deliver_to from dbmail_aliases where > '[EMAIL PROTECTED]' regexp alias; > +------------+------------+ > > | alias | deliver_to | > > +------------+------------+ > > | postmaster | 6 | > > +------------+------------+ > > > We need to be mindful of cross-SQL portability. What do you think about > the LIKE alternative using only % and _, which are standard SQL since > forever? > > Aaron > > Micah <[EMAIL PROTECTED]> said: > > Aaron, > > > > I'm still not sure I support the idea, but: > > > > SELECT deliver_to FROM dbmail_aliases WHERE 'deliveryaddress' REGEXP > > alias; > > > > should work fine in MySQL, dunno if there's an equivilent statement in PG > > though. > > > > -Micah > > > > On Tuesday 19 October 2004 01:05 pm, Aaron Stone wrote: > >> Blake Mitchell <[EMAIL PROTECTED]> said: > >> > Why not take this one step further, and go with full glob or regex > >> > support? This would allow nearly any conceivable case. > >> > >> I don't know how we'd support this in the database. We'd use the alias > >> column of the dbmail_aliases table like this: > >> > >> alias | deliver_to > >> ------------------------------------- > >> [EMAIL PROTECTED] | 9 > >> [EMAIL PROTECTED] | [EMAIL PROTECTED] > >> [EMAIL PROTECTED] | 34 > >> ------------------------------------- > >> > >> Except that this doesn't work because, at least MySQL, cannot use the > >> REGEX keyword like this: > >> > >> SELECT deliver_to FROM dbmail_aliases WHERE '[EMAIL PROTECTED]' REGEX > >> alias; > >> > >> However... if we use SQL wildcards, you're in luck: > >> > >> alias | deliver_to > >> ------------------------------------- > >> [EMAIL PROTECTED] | [EMAIL PROTECTED] > >> > >> SELECT deliver_to FROM dbmail_aliases WHERE '[EMAIL PROTECTED]' LIKE > >> alias; > >> > >> Works perfectly. Could someone test PostgreSQL, too? This might solve > >> everything in one fell swoop... > >> > >> Aaron > >> > >> -- > >> _______________________________________________ > >> Dbmail-dev mailing list > >> Dbmail-dev@dbmail.org > >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > _______________________________________________ > > Dbmail-dev mailing list > > Dbmail-dev@dbmail.org > > http://twister.fastxs.net/mailman/listinfo/dbmail-dev
