Postgres Pro
Downloads
Home   >   mailing lists

correlated query as a column and where clause - Mailing list pgsql-general

From salah jubeh
Subject correlated query as a column and where clause
Date
Msg-id 376043.62368.qm@web161514.mail.bf1.yahoo.com
Whole thread Raw
Responses Re: correlated query as a column and where clause
Re: correlated query as a column and where clause
List pgsql-general
Tree view
Hello All,

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_'


Thanks in advance


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Migrating Data Across Major Versions
Next
From: Harald Armin Massa
Date:
Subject: Re: correlated query as a column and where clause