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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
