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 B7AB0D1B7DC for ; Fri, 25 Jun 2004 10:47:57 -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 09451-05 for ; Fri, 25 Jun 2004 13:47:57 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id C4503D1B7D4 for ; Fri, 25 Jun 2004 10:47:51 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i5PCuHeR009179; Fri, 25 Jun 2004 15:56:17 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i5PCuHVe009175; Fri, 25 Jun 2004 15:56:17 +0300 Date: Fri, 25 Jun 2004 15:56:17 +0300 (EEST) From: Achilleus Mantzios To: =?iso-8859-2?Q?Przemys=B3aw_S=B3upkowski?= Cc: Lista dyskusyjna pgsql-sql Subject: Re: Join columns In-Reply-To: <002701c45ab8$092d69f0$880f10ac@win.coig.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/260 X-Sequence-Number: 18205 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