| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Is this a bug???? |
| Date: | 2005-12-05 00:24:14 |
| Message-ID: | 11042.1133742254@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes:
> If I run this query:
> select objectid,defaulttermsofpayment from prototype.customers
> where
> objectid = '336A0451-D9E8-7C11-6333-C17DF18E8979'
> I get the following answer:
> "336A0451-D9E8-7C11-6333-C17DF18E8979";"null"
> If I run this query I get *no* results:
> select objectid,defaulttermsofpayment from prototype.customers
> where
> defaulttermsofpayment is null
> Is this a bug?
Not unless you can prove that the defaulttermsofpayment field is
actually null, and not the string "null" as it appears to be.
(What client-side software are you using? psql wouldn't display
the row like that, nor anything else I'm familiar with.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2005-12-05 08:35:10 | Re: date overflows |
| Previous Message | Qingqing Zhou | 2005-12-04 23:10:41 | Re: Is this a bug???? |