Skip site navigation (1) Skip section navigation (2)

Re: Is this a bug????

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 (view raw or flat)
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

In response to

pgsql-bugs by date

Next:From: Kris JurkaDate: 2005-12-05 08:35:10
Subject: Re: date overflows
Previous:From: Qingqing ZhouDate: 2005-12-04 23:10:41
Subject: Re: Is this a bug????

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group