From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Przemysław Słupkowski <przemyslaw.slupkowski@euro.coig.pl>
Cc: Lista dyskusyjna pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Join columns
Date: Fri, 25 Jun 2004 15:56:17 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0406251554330.9135-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <002701c45ab8$092d69f0$880f10ac@win.coig.com>
O kyrios Przemys³aw S³upkowski egrapse stis Jun 25, 2004 :
> 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
Maybe use coalesce to deal with nulls.
>
>
>
--
-Achilleus
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: achill@matrix.gatewaynet.com, przemyslaw.slupkowski@euro.coig.pl
Subject: Re: Join columns
In-Reply-To: <Pine.LNX.4.44.0406251554330.9135-100000@matrix.gatewaynet.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