Re: correlated query as a column and where clause

Поиск
Список
Период
Сортировка
От Harald Armin Massa
Тема Re: correlated query as a column and where clause
Дата
Msg-id BANLkTimTnxqD=Br8wpzjJ1RdKQT7ksX4AQ@mail.gmail.com
обсуждение исходный текст
Ответ на correlated query as a column and where clause  (salah jubeh <s_jubeh@yahoo.com>)
Ответы Re: correlated query as a column and where clause
Список pgsql-general
Дерево обсуждения
I am wondering,  why I can not add the following  '  A > 10'  in the where  clause  i.e.   'where nspname !~* 'pg_'  and A > 10'

Select nspname, (SELECT count(*) as count FROM pg_tables where schemaname = nspname) as A
FROM pg_namespace
where nspname !~* 'pg_'


what you are looking for is the having clause

Select nspname, count(1) 
 FROM pg_tables 
where nspname !~* 'pg_' 
group by nspname
having count(1)  >10

best wishes

Harald

--
Harald Armin Massa     www.2ndQuadrant.com
PostgreSQL  Training, Services  and Support

2ndQuadrant Deutschland GmbH    
GF: Harald Armin Massa
Amtsgericht Stuttgart, HRB 736399

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

Предыдущее
От: salah jubeh
Дата:
Сообщение: correlated query as a column and where clause
Следующее
От: Chris Curvey
Дата:
Сообщение: Re: correlated query as a column and where clause