Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1gm3Tx-0001Tm-5T
	for pgsql-sql@arkaria.postgresql.org; Tue, 22 Jan 2019 21:21:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1gm3Tu-0007G4-Fu
	for pgsql-sql@arkaria.postgresql.org; Tue, 22 Jan 2019 21:21:14 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <ertan.kucukoglu@1nar.com.tr>)
	id 1gm3Tu-0007Fx-2d
	for pgsql-sql@lists.postgresql.org; Tue, 22 Jan 2019 21:21:14 +0000
Received: from mta09.doruk.net.tr ([212.58.5.119])
	by makus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <ertan.kucukoglu@1nar.com.tr>)
	id 1gm3Tq-0000oT-57
	for pgsql-sql@lists.postgresql.org; Tue, 22 Jan 2019 21:21:12 +0000
Received: from cmail19.webkontrol.doruk.net.tr ([212.58.6.99])
	by mta09.doruk.net.tr with esmtp (Exim 4.86)
	(envelope-from <ertan.kucukoglu@1nar.com.tr>)
	id 1gm3N5-0002lR-Kb
	for pgsql-sql@lists.postgresql.org; Wed, 23 Jan 2019 00:14:11 +0300
Received: from DESKTOPM80CG12 ([31.206.45.189])
        by cmail19.webkontrol.doruk.net.tr (IceWarp 11.1.2.0) with ASMTP id
 201901230021069061
        for <pgsql-sql@lists.postgresql.org>; Wed, 23 Jan 2019 00:21:06 +0300
From: =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr>
To: <pgsql-sql@lists.postgresql.org>
Subject: Converting from MySQL
Date: Wed, 23 Jan 2019 00:21:03 +0300
Message-ID: <000101d4b298$61f471d0$25dd5570$@1nar.com.tr>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AdSyl4EapaDdbiz+R+q8lbDiCwdJJA==
Content-Language: tr
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

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=3D'%s'

Any help is appreciated.

Thanks & regards,
Ertan K=FC=E7=FCko=F0lu