Re: PostgreSQL equivelant of this MySQL query - Mailing list pgsql-general

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@domain.com' 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