| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | Przemysław Słupkowski <przemyslaw(dot)slupkowski(at)euro(dot)coig(dot)pl> |
| Cc: | Lista dyskusyjna pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Join columns |
| Date: | 2004-06-25 12:56:17 |
| Message-ID: | Pine.LNX.4.44.0406251554330.9135-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Przemysław Słupkowski | 2004-06-25 13:26:34 | Join columns |
| Previous Message | Richard Huxton | 2004-06-25 10:18:53 | Re: Normalising an existing table - how? |