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