Complete Linux/Complete Linux.iso/docs/apps/database/postgres/postgre1.z/postgre1/bench/query9

Text File | 1992-08-27 | 940 b | 5 lines

retrieve into temp (t1.all, t2unique1=t2.unique1, t2unique2=t2.unique2, t2two=t2.two, t2four=t2.four, t2ten=t2.ten, t2twenty= t2.twenty, t2hundred=t2.hundred, t2thousand= t2.thousand,t2twothousand= t2.twothousand, t2fivethous= t2.fivethous, t2tenthous= t2.tenthous, t2odd= t2.odd, t2even= t2.even, t2stringu1= t2.stringu1, t2stringu2= t2.stringu2, t2string4= t2.string4) from t1 in tenk1, t2 in tenk2 where (t1.unique2 = t2.unique2) and (t2.unique2 < 1000)
destroy temp
retrieve into temp (t1.all, t2unique1=t2.unique1, t2unique2=t2.unique2, t2two=t2.two, t2four=t2.four, t2ten=t2.ten, t2twenty= t2.twenty, t2hundred=t2.hundred, t2thousand= t2.thousand,t2twothousand= t2.twothousand, t2fivethous= t2.fivethous, t2tenthous= t2.tenthous, t2odd= t2.odd, t2even= t2.even, t2stringu1= t2.stringu1, t2stringu2= t2.stringu2, t2string4= t2.string4) from t1 in tenk1, t2 in tenk2 where (t1.unique2 = t2.unique2) and (t2.unique2 < 1000)
destroy temp