Converting from MySQL - Mailing list pgsql-sql

From Ertan Küçükoğlu
Subject Converting from MySQL
Date
Msg-id 000101d4b298$61f471d0$25dd5570$@1nar.com.tr
Whole thread Raw
Responses Re: Converting from MySQL
List pgsql-sql
Hello,

I am trying to install a mail server using PostgreSQL on a Debian 9 Stretch.
Document I am following is for MySQL. I converted other simple SQL commands.
Failed to find PostgreSQL equivalent for below one because I did not
understand what it does in the first place.

SELECT
CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
FROM users WHERE email='%s'

Any help is appreciated.

Thanks & regards,
Ertan Küçükoğlu



pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: How to create index on json array in postgres
Next
From: "David G. Johnston"
Date:
Subject: Re: Converting from MySQL