User-Agent: Cyrus-JMAP/3.5.0-alpha0-4911-g925b585eab-fm-20220323.003-g925b585e
Mime-Version: 1.0
Message-Id: <81d77fc9-c28c-4bd6-8efc-656622811dbb@www.fastmail.com>
In-Reply-To: 
 <164790256029.701350.8616885741554177403@wrigleys.postgresql.org>
References: <164790256029.701350.8616885741554177403@wrigleys.postgresql.org>
Date: Thu, 24 Mar 2022 22:48:31 -0300
From: "Euler Taveira" <euler@eulerto.com>
To: ranasalal@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: GENERATED ALWAYS AS - Not Consistent with MD5
Content-Type: multipart/alternative;
 boundary=317504a529b5400789878c383dc505de
Archived-At: 
 <https://www.postgresql.org/message-id/81d77fc9-c28c-4bd6-8efc-656622811dbb%40www.fastmail.com>
Precedence: bulk

--317504a529b5400789878c383dc505de
Content-Type: text/plain

On Mon, Mar 21, 2022, at 7:42 PM, PG Doc comments form wrote:
> In my table definition - my Id Column is defined as ```Id TEXT PRIMARY KEY
> GENERATED ALWAYS AS (MD5(date_part('epoch', Inv_Date)::TEXT || TerminalId ||
> GradeId || Ownership_Code)) STORED,```
> 
> But the value generated is not consistent upon insertion.
> To confirm we checked by generating MD5 on SELECT and comparing the Id,
> they're two completely different values.
> 
It works for me. Could you provide a self-contained test case? What's your
current version?

This list is for documentation discussion. For general questions, use
pgsql-general. For bug reports, use pgsql-bugs.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

--317504a529b5400789878c383dc505de
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div>On Mon, Mar 21,=
 2022, at 7:42 PM, PG Doc comments form wrote:<br></div><blockquote type=
=3D"cite" id=3D"qt" style=3D""><div>In my table definition - my Id Colum=
n is defined as ```Id TEXT PRIMARY KEY<br></div><div>GENERATED ALWAYS AS=
 (MD5(date_part('epoch', Inv_Date)::TEXT || TerminalId ||<br></div><div>=
GradeId || Ownership_Code)) STORED,```<br></div><div><br></div><div>But =
the value generated is not consistent upon insertion.<br></div><div>To c=
onfirm we checked by generating MD5 on SELECT and comparing the Id,<br><=
/div><div>they're two completely different values.<br></div><div><br></d=
iv></blockquote><div>It works for me. Could you provide a self-contained=
 test case? What's your<br></div><div>current version?<br></div><div><br=
></div><div>This list is for documentation discussion. For general quest=
ions, use<br></div><div>pgsql-general. For bug reports, use pgsql-bugs.<=
br></div><div><br></div><div><br></div><div id=3D"sig112409080"><div cla=
ss=3D"signature">--<br></div><div class=3D"signature">Euler Taveira<br><=
/div><div class=3D"signature">EDB&nbsp;&nbsp; <a href=3D"https://www.ent=
erprisedb.com/">https://www.enterprisedb.com/</a><br></div></div><div><b=
r></div></body></html>
--317504a529b5400789878c383dc505de--