correlated query as a column and where clause

Поиск
Список
Период
Сортировка
От salah jubeh
Тема correlated query as a column and where clause
Дата
Msg-id 376043.62368.qm@web161514.mail.bf1.yahoo.com
обсуждение исходный текст
Ответы Re: correlated query as a column and where clause  (Harald Armin Massa <harald@2ndQuadrant.com>)
Re: correlated query as a column and where clause  (Chris Curvey <chris@chriscurvey.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Migrating Data Across Major Versions
Следующее
От: Harald Armin Massa
Дата:
Сообщение: Re: correlated query as a column and where clause