Postgres Pro
Downloads
Home   >   mailing lists

How to select based on the condition of a column exists - Mailing list pgsql-general

From Shaozhong SHI
Subject How to select based on the condition of a column exists
Date
Msg-id CA+i5JwbpxnR2+Jb++hWG-98csG_rMbSaKbcg74+TUM7ez6c6VQ@mail.gmail.com
Whole thread Raw
Responses Re: How to select based on the condition of a column exists
List pgsql-general
Tree view
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.

Regards,

David

pgsql-general by date:

Previous
From: "Lahnov, Igor"
Date:
Subject: RE: Unable to start replica after failover
Next
From: "David G. Johnston"
Date:
Subject: Re: How to select based on the condition of a column exists