Re: How to select based on the condition of a column exists

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to select based on the condition of a column exists
Дата
Msg-id CAKFQuwZO_mVPVHiB1Nus0XzhzmG5ZL+NWVmf33sfha0HH0fxkg@mail.gmail.com
обсуждение исходный текст
Ответ на How to select based on the condition of a column exists  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-general
On Fri, Aug 26, 2022 at 7:01 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
The following does not work.
select count(test) from table where exists (select test from table)


How to  select based on the condition of a column exists?   It column test is not exists, a message need to be returned.


You have to query the system catalog (or information schema) for the absence of an expected row.  Otherwise the only message you will end up returning is "column not found" since you cannot write and execute an SQL query without knowing and defining its entire structure.

Alternatively, you write a function with an exception block.

David J.

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

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: How to select based on the condition of a column exists
Следующее
От: Ron
Дата:
Сообщение: Re: Restriction on table partition expressions