CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT again

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT again
Дата
Msg-id 4327CDF0.000002.17993@pantene.yandex.ru
обсуждение исходный текст
Ответы Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: MS SQL - PostgreSQL
Следующее
От: Oleg
Дата:
Сообщение: how to list rules?