Re: [GENERAL] PostgreSQL equivelant of this MySQL query

2007-07-15 Thread paddy carroll
select split_part(usr_email,'@',2) ||split_part(usr_email,'@',1) from .. 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

Re: [GENERAL] PostgreSQL equivelant of this MySQL query

2007-07-13 Thread Madison Kelly
Steve Atkins wrote: On Jul 13, 2007, at 6:39 PM, 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.

Re: [GENERAL] PostgreSQL equivelant of this MySQL query

2007-07-13 Thread Steve Atkins
On Jul 13, 2007, at 6:39 PM, 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 CONC

Re: [GENERAL] PostgreSQL equivelant of this MySQL query

2007-07-13 Thread Madison Kelly
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,'@',

[GENERAL] PostgreSQL equivelant of this MySQL query

2007-07-13 Thread Madison Kelly
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_INDE