| From: | Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net> |
|---|---|
| To: | "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | selectecting not null varchars. |
| Date: | 2000-02-24 19:46:54 |
| Message-ID: | 38B58AAE.B28DD6CB@selectacast.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed Loehr | 2000-02-24 20:04:40 | Re: [INTERFACES] selectecting not null varchars. |
| Previous Message | Mike Mascari | 2000-02-24 15:50:30 | Re: [INTERFACES] selectecting not null varchars. |