find the number of row for each tables

Поиск
Список
Период
Сортировка
Искать
От
Patrick Coulombe
Тема
find the number of row for each tables
Дата
Msg-id
006901bfd5ac$cf9c4740$5116c918@videotron.ca
Список
Дерево обсуждения
Re: find the number of row for each tables NRonayette <r97m10@socotec.fr>
Re: find the number of row for each tables "D. Duccini" <duccini@backpack.com>
hi,
here's the question : if I do this query on my database :

SELECT * from friends, strangers WHERE friends.f_id = strangers.s_id AND
friends.categorie = 1
----------
88 rows

and I need to do this query to know how many rows just for my table friends
(not both table) :

SELECT * from friends WHERE friends.f_id = strangers.s_id AND
friends.categorie = 1
----------
80 rows


Can I just do 1 query and be able to find the number of row for each tables?
Hope to be understand...

Patrick


В списке pgsql-novice по дате отправления
От: D. Duccini
Дата:
От: Anthony E. Greene
Дата:
FAQ