How to get Rows Count - Mailing list pgsql-sql

From Abdul Wahab Dahalan
Subject How to get Rows Count
Date
Msg-id 40429AA1.4060905@mimos.my
Whole thread Raw
List pgsql-sql
>
>
>a       b      d    c  
>01      02     b    *  
>01      02     a    *  
>02      03       
>02      04     b    *  
>02      04     a    *  
>03      05  
>04      06  
>
If I've a table like above, how do I make a query to get rows count that 
doesnt have '*' in it.

Can we have other queries than this : Select count(c) from tablename 
where c !='*';
or Select count(c) from tablename where c <> '*';




pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Trouble with composite types
Next
From: Michael Chaney
Date:
Subject: Re: Postgres DB