pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Re: Join columns
2+ messages / 2 participants
[nested] [flat]

* Re: Join columns
@ 2004-06-25 12:56  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  parent: Przemysław Słupkowski <przemyslaw.slupkowski@euro.coig.pl>
  0 siblings, 0 replies; 2+ messages in thread

From: Achilleus Mantzios @ 2004-06-25 12:56 UTC (permalink / raw)
  To: Przemysław Słupkowski <przemyslaw.slupkowski@euro.coig.pl>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Join columns
@ 2004-06-25 13:26  Przemysław Słupkowski <przemyslaw.slupkowski@euro.coig.pl>
  0 siblings, 1 reply; 2+ messages in thread

From: Przemysław Słupkowski @ 2004-06-25 13:26 UTC (permalink / raw)
  To: pgsql-sql

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-06-25 13:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-25 13:26 Join columns Przemysław Słupkowski <przemyslaw.slupkowski@euro.coig.pl>
2004-06-25 12:56 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>

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