In postgresql you can do something like select 'maildir:' || maildir as mail, uid, ... through dovecot-sql.conf Is there a mysql equivalent for adding 'maildir:' as a prefix to the 'mail' location ?
after poking around on the mysql.org manual user comments for a while,
this seems to be the equivalent
user_query = SELECT CONCAT('maildir:', maildir) as mail, homedir as
home, uid, gid FROM postfix_users WHERE email = '%u'
Chris Cappuccio [chris at nmedia.net] wrote:> In postgresql you can do something like
>
> select 'maildir:' || maildir as mail, uid, ...
>
> through dovecot-sql.conf
>
> Is there a mysql equivalent for adding 'maildir:' as a prefix to
the 'mail'
> location ?
On 2006-08-04 13:57:44 -0700, Chris Cappuccio wrote:> In postgresql you can do something like > > select 'maildir:' || maildir as mail, uid, ... > > through dovecot-sql.conf > > Is there a mysql equivalent for adding 'maildir:' as a prefix to the 'mail' > location ?[[[ user_query = SELECT concat('/some/path/', maildir) as home, concat('maildir:/some/other/path/', maildir) as mail, 12345 AS uid, 12345 AS gid FROM mailbox WHERE username = '%u' ]]] darix -- openSUSE - SUSE Linux is my linux openSUSE is good for you www.opensuse.org