Re: correlated query as a column and where clause

From: Harald Armin Massa <harald(at)2ndQuadrant(dot)com>
To: salah jubeh <s_jubeh(at)yahoo(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: correlated query as a column and where clause
Date: 2011-04-15 15:26:45
Message-ID: BANLkTimTnxqD=Br8wpzjJ1RdKQT7ksX4AQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Curvey 2011-04-15 15:28:39 Re: correlated query as a column and where clause
Previous Message salah jubeh 2011-04-15 15:22:19 correlated query as a column and where clause