<meta content=3D"text/html; charset=3DUTF-8" http-equiv=3D"Content-Type=
">
body p { margin-bottom: 0cm; margin-top: 0pt; }
<body style=3D"direction: ltr;"
bidimailui-detected-decoding-type=3D"UTF-8" bgcolor=3D"#ffffff"
text=3D"#000000">
On 09/01/2011 01:35 PM, Grzegorz Ja=C5=9Bkiewicz wrote:
<blockquote
cite=3D"mid:CAJY59_h6TqWfh3NKxfDCq1Pb9hBcYGBqxb5h+czWcgLj4ETeGQ@mail.gmail.=
com"
type=3D"cite">
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <a class=3D=
"moz-txt-link-rfc2396E" href=3D"mailto:sim@compulab.co.il"><sim@compulab=
.co.il> wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=3D# create table tt(a int, b varchar);
CREATE TABLE
postgres=3D# insert into tt values(10,'hello');
INSERT 0 1
postgres=3D# select md5(array_to_string(array_agg(md5(tt::text)),'')) from
I do that as well, but it might have questionable perf=
ormance when
your table has 16M rows, and is 50GB +
I don't need performance. This is for regression testing for a
new database version. I want to run my functions in the old db and
the new db and when it modifies a table, I want to be able to
check that the tables are the same.
Sim