Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1g9VN6-0008GU-3N
	for pgsql-general@arkaria.postgresql.org; Mon, 08 Oct 2018 13:14:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1g9VN4-0003Ta-JS
	for pgsql-general@arkaria.postgresql.org; Mon, 08 Oct 2018 13:14:50 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <spam_from_pgsql_lists@chezphil.org>)
	id 1g9VN4-0003TT-6p
	for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 13:14:50 +0000
Received: from ec2-34-255-138-49.eu-west-1.compute.amazonaws.com
 ([34.255.138.49] helo=zimbabwe.chezphil.org)
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <spam_from_pgsql_lists@chezphil.org>)
	id 1g9VN1-0006oQ-Ne
	for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 13:14:48 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=chezphil.org mappendix.com; s=20171026; h=Content-Type:MIME-Version:
	References:In-Reply-To:Message-ID:Subject:Date:To:From:Sender:Reply-To:Cc:
	Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date:
	Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:
	List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive;
	 bh=Ud2iu/C/ZCKd4OUqmSdMxMU5I5XJfTKgcGEVRLGpULU=; b=lvmMr5k0tPE3IPddov6J6Zbff
	NycNOsVSThWfp8YhfFrQdbgIceLYxC9kAZ3aOe60C5/AqPMZkDsFb76e6mjneCClPX2aU1U5P0m9r
	P6FFLIS9b4OSEeJ6ooiIMyaSwC4Chbrf7hP3THPdX1/LJbZdA3/ryoVirTAWAgipIYZms=;
Received: from localhost ([127.0.0.1] helo=chezphil.org)
	by zimbabwe.chezphil.org with esmtp (Exim 4.89)
	(envelope-from <spam_from_pgsql_lists@chezphil.org>)
	id 1g9VMz-0000km-Gu
	for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 14:14:45 +0100
Received: from localhost ([::ffff:127.0.0.1]) by zimbabwe
  with smtp (dmsmtpd 0.00001); Mon, 08 Oct 2018 14:14:45 +0100
From: "Phil Endecott" <spam_from_pgsql_lists@chezphil.org>
To: "ROS Didier" <didier.ros@edf.fr>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: Mon, 08 Oct 2018 14:14:45 +0100
Subject: RE: Why the index is not used ?
Message-ID: <1539004485308@dmwebmail.dmwebmail.chezphil.org>
In-Reply-To: <0f723a9063f14e2096eb36e720a8048b@PCYINTPEXMU001.NEOPROD.EDF.FR>
References: <0f723a9063f14e2096eb36e720a8048b@PCYINTPEXMU001.NEOPROD.EDF.FR>
X-Mailer: Decimail Webmail 3alpha16
MIME-Version: 1.0
Content-Type: text/plain; format="flowed"; charset="UTF-8"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Precedence: bulk

ROS Didier wrote:
> Can you give some examples of these encryption function 
> that doesn't salt the data.

encrypt(data, 'motdepass', 'aes')


Regards, Phil.