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
Re: correlated query as a column and where clause
Список 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 по дате отправления: