Re: how does NOT work?
От | tony |
---|---|
Тема | Re: how does NOT work? |
Дата | |
Msg-id | 1019664373.23158.56.camel@vaio обсуждение исходный текст |
Ответ на | Re: how does NOT work? ("ARP" <arnaud.mlist1@free.fr>) |
Ответы |
Re: how does NOT work?
Re: how does NOT work? |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: