Re: Is this a bug????

Joost Kraaijeveld <J.Kraaijeveld@Askesis.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