GENERATED ALWAYS AS - Not Consistent with MD5

2022-03-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-generated-columns.html Description: 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

Re: GENERATED ALWAYS AS - Not Consistent with MD5

2022-03-24 Thread Euler Taveira
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 cons