Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id CB3974759AF
	for <pgsql-sql@postgresql.org>; Thu,  7 Nov 2002 06:41:01 -0500 (EST)
Received: from web80306.mail.yahoo.com (web80306.mail.yahoo.com
 [66.218.79.22])
	by postgresql.org (Postfix) with SMTP id 3DAEA475461
	for <pgsql-sql@postgresql.org>; Thu,  7 Nov 2002 06:41:01 -0500 (EST)
Message-ID: <20021107114103.43007.qmail@web80306.mail.yahoo.com>
Received: from [203.87.150.116] by web80306.mail.yahoo.com via HTTP;
	Thu, 07 Nov 2002 03:41:03 PST
Date: Thu, 7 Nov 2002 03:41:03 -0800 (PST)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: Weird NULL behavior
To: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/89
X-Sequence-Number: 10231

Hi:
 
  Has anyone encountered this before?
  SELECT CAST ( (NULL*NULL) AS NUMERIC(2,0));

  
  returns the following error message:
  Cannot cast type '"char"' to '"numeric"'

  But the following sql statements returns NULL:
  select NULL:
  select NULL * NULL;
  select cast ( NULL as NUMERIC(2,0));
  

Thank you in advance,
ludwig. 

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com