selectecting not null varchars.

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема selectecting not null varchars.
Дата
Msg-id 38B58AAE.B28DD6CB@selectacast.net
обсуждение исходный текст
Ответы Re: [INTERFACES] selectecting not null varchars.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-interfaces
I have a table with some text strings and I want to select row where the
text fields have a value in them.

I tried  :
select * from directory where length(h) > 0 ;
and got:
ERROR:  Null input to textlen

So I tried:
select * from directory where h != null AND length(h) > 0 ;
and got:
ERROR:  parser: parse error at or near "and"

In fact this:select * from directory where h != null  ;
... gets you this:
ERROR:  parser: parse error at or near ";"

Trying to select where it is equal to null works.  Trying to select
where an int is not equal to a certain value works.  But I cannot select
where a varchar (or int) is not equal to null.



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Rob Brown-Bayliss
Дата:
Сообщение: creating a db with libpq
Следующее
От: Ed Loehr
Дата:
Сообщение: Re: [INTERFACES] selectecting not null varchars.