From: Przemysław Słupkowski <przemyslaw.slupkowski@euro.coig.pl>
To: Lista dyskusyjna pgsql-sql <pgsql-sql@postgresql.org>
Subject: Join columns
Date: Fri, 25 Jun 2004 15:26:34 +0200
Message-ID: <002701c45ab8$092d69f0$880f10ac@win.coig.com> (raw)
Hi
How can I generate md5 chcecksum for a row in table. I have 47 columns in table and I want to generate chceck sum to check is integrity od data.
I want to do something like this
select md5((idTowBK || SKDK || SKDT || SKGR || SKIR || SKKL || SKKR || SKLM || SKNZ || SKOP || SKPR)::varchar)
from FARM_BKam limit 10
and its works :-)
But when I increase number of columns higher than 12 then return's null string
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: przemyslaw.slupkowski@euro.coig.pl
Subject: Re: Join columns
In-Reply-To: <002701c45ab8$092d69f0$880f10ac@win.coig.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox