Re: Nulls get converted to 0 problem

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(at)svana(dot)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