Hello! According to Tom's message http://archives.postgresql.org/pgsql-general/2005-06/msg00476.php we have the stuff supposed to return number of rows affected by CREATE .. AS SELECT or SELECT ... INTO in 8.1 beta. The patch is at place, though PQcmdTuples returns nothing. It's not a big surprise considering PQcmdTuples likes INSERT, DELETE, FETCH or MOVE only. The real pain is cmdStatus does not contain number of affected rows. Any suggestions? Is it possible to calculate number of rows in newly created table without explicit SELECT COUNT(*)? I don't use PL/pgSQL. Thanks a lot. -- Best regards Ilja Golshtein ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org