X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0DC0FD1BA62 for ; Fri, 25 Jun 2004 10:24:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94231-10 for ; Fri, 25 Jun 2004 13:24:30 +0000 (GMT) Received: from coig.katowice.pl (pluton.coig.katowice.pl [195.39.216.12]) by svr1.postgresql.org (Postfix) with ESMTP id 45B4ED1B7EF for ; Fri, 25 Jun 2004 10:24:22 -0300 (ADT) Received: from [195.39.216.20] (account przemyslaw.slupkowski@euro.coig.pl HELO slupkowski) by coig.katowice.pl (CommuniGate Pro SMTP 4.1.8) with ESMTP id 1216445 for pgsql-sql@postgresql.org; Fri, 25 Jun 2004 15:24:24 +0200 Message-ID: <002701c45ab8$092d69f0$880f10ac@win.coig.com> From: =?iso-8859-2?Q?Przemys=B3aw_S=B3upkowski?= To: "Lista dyskusyjna pgsql-sql" Subject: Join columns Date: Fri, 25 Jun 2004 15:26:34 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0024_01C45AC8.CC4D8D10" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/259 X-Sequence-Number: 18204 This is a multi-part message in MIME format. ------=_NextPart_000_0024_01C45AC8.CC4D8D10 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi=20 How can I generate md5 chcecksum for a row in table. I have 47 columns in t= able 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 str= ing ------=_NextPart_000_0024_01C45AC8.CC4D8D10 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

How can I generate md5 chcecksum for a row= in=20 table. I have 47 columns in table and I want to generate chceck sum to chec= k is=20 integrity od data.

I want to do something like this

select md5((idTowBK || SKDK || SKDT || SKG= R || SKIR=20 || SKKL || SKKR || SKLM || SKNZ || SKOP || SKPR)::varchar)
from= =20 FARM_BKam limit 10

and its works :-)

But when I increase number of columns high= er than=20 12 then return's null string

------=_NextPart_000_0024_01C45AC8.CC4D8D10--