On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <sim(at)compulab(dot)co(dot)il> wrote:
> On 09/01/2011 12:26 PM, Pavel Stehule wrote:
>>
>> Hello
>>
>> postgres=# create table tt(a int, b varchar);
>> CREATE TABLE
>> postgres=# insert into tt values(10,'hello');
>> INSERT 0 1
>>
>> postgres=# select md5(array_to_string(array_agg(md5(tt::text)),'')) from
I do that as well, but it might have questionable performance when
your table has 16M rows, and is 50GB +
--
GJ