Madison Kelly wrote:
Hi all,
I am reading through some docs on switching to Postfix with a SQL
backend. The docs use MySQL but I want to use PgSQL so I am trying to
adapt as I go. I am stuck though; can anyone help give me the PgSQL
equiv. of:
SELECT
CONCAT(SUBSTRING_INDEX(usr_email,'@',-1),'/',SUBSTRING_INDEX(usr_email,'@',1),'/')
FROM users WHERE usr_id=1;
If the 'usr_email' value is 'person@xxxxxxxxxx' this should return
'domain.com/person'.
Thanks for the help!
Madison
Bah, answered my own question after posting. :)
For the record:
SELECT substring(usr_email FROM '@(.*)')||'/'||substring(usr_email FROM
'(.*)@') FROM users WHERE usr_id=1;
Sorry for the line noise!
Madi