Re: Retrieving NULL records
От
Тема
Re: Retrieving NULL records
Дата
Msg-id
6312635$10594607333f26167d23d2a4.83384765@config11.schlund.de
Список
Дерево обсуждения
Re: Retrieving NULL records <email@juergen-cappel.de>
Re: Retrieving NULL records "Mel Jamero" <mel@gmanmi.tv>
Re: Retrieving NULL records Nabil Sayegh <postgresql@e-trolley.de>
Shouldn't = NULL be considered a syntax error ? Tom Lane schrieb am 29.07.2003, 07:41:15: > "psql novice" writes: > > stock=> select * from stock where qty = NULL; > > The correct incantation is > > select * from stock where qty IS NULL; > > Ordinary comparisons involving NULL always fail (or more accurately, > return NULL). You have to use the special "is null" operator instead. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-novice по дате отправления
