Re: Nulls get converted to 0 problem - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Nulls get converted to 0 problem
Date
Msg-id 20030609131731.GB32692@svana.org
Whole thread Raw
In response to Re: Nulls get converted to 0 problem  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
On Fri, Jun 06, 2003 at 01:34:16PM -0400, Mike Mascari wrote:
> There also isn't any notion of typed NULLs. At least the C++ example
> has a zero-initialized pointer to a type.

Dunno about the rest but this is false. NULLs can be typed:

# select null::int4 as f into temp a;
SELECT
# \d a
     Table "pg_temp_1.a"
 Column |  Type   | Modifiers
--------+---------+-----------
 f      | integer |

Not that it usually matters.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: Ruben
Date:
Subject: Re: Postmaster only takes 4-5% CPU
Next
From: "Robert Fitzpatrick"
Date:
Subject: Pg_dumpall from different versions