require"postgres" local env = assert (luasql.postgres ()) local conn = assert (env:connect ("luasql-test", "tomas")) local cur = assert (conn:execute ("select count(*) from t1")) local total = tonumber (cur:fetch()) cur:close() local aleatorio = math.random(total) local cur = assert (conn:execute ("select * from t1, t2 where b = d and a != "..2*aleatorio)) cgilua.htmlheader() cgilua.put ("Aleatorio = "..aleatorio.."
\n") local a,b,c,d = cur:fetch() cgilua.put ("\n") while a do -- cgilua.put ("") a,b,c,d = cur:fetch() end cgilua.put ("
",a,"",b,"",c,"",d,"
\n") cur:close() conn:close() env:close()