Row Count
| От | Sergey Gigoyan |
|---|---|
| Тема | Row Count |
| Дата | |
| Msg-id | CAFaFzo6uSe8Q0Y9tzfQk_rBxSnQy+Z-CNmbTjXNEJ=QBFOf8XQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Row Count
Re: Row Count Re: Row Count |
| Список | pgsql-novice |
How can I get selected row count in one statement?
For example, I can do that by two select statements
select id, name, addrress, (select count(*) from(select id
from users
where name<>'examplename')
from users
where name<>'examplename'
or
declare rowcount integer
...............
rowcount:=select count(*) from(select id
from users
where name<>'examplename') as rst
select id, name, address, rowcount as rowcount
from users
where name<>'examplename'
For example, I can do that by two select statements
select id, name, addrress, (select count(*) from(select id
from users
where name<>'examplename')
from users
where name<>'examplename'
or
declare rowcount integer
...............
rowcount:=select count(*) from(select id
from users
where name<>'examplename') as rst
select id, name, address, rowcount as rowcount
from users
where name<>'examplename'
В списке pgsql-novice по дате отправления: