... or see my answer a second ago about (c LIKE 'a%') IS NOT TRUE which
will also work.
Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of tony
> Sent: Wednesday, April 24, 2002 12:06 PM
> To: ARP
> Cc: postgres list
> Subject: Re: [GENERAL] how does NOT work?
>
>
> On Wed, 2002-04-24 at 17:55, ARP wrote:
> > > I guess select count(*) from individu where type2 is null
> will return 5717 (18417-12619-81)
> >
> > >Still don't understand the logic - I just want cells that don't start
> > >with "a" I don't care if they contain null values or not.
>
> > select count(*) from individu where type2 is null or type2 not like 'a%'
>
> "or" works here but not in some of the more complex joins I am doing
> elsewhere. I will be using "-" and "0" a lot more from now on!
>
> Thanks again
>
> Tony
>
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
> Macromedia UltraDev with PostgreSQL
> http://www.animaproductions.com/ultra.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
