Quick Links

change null to 0 in SQL script

From:	"Karl Raven" <lcaasia(at)pd(dot)jaring(dot)my>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	change null to 0 in SQL script
Date:	2002-01-03 05:00:44
Message-ID:	a10ojd$1v4q$1@news.tht.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

I like to change a null value of a query to 0 in the SQL script. I know how
to do it in MS-SQL server and MS-Access but those commands does not work in
pg-sql.

Anyone has any ideas?

Thanks

Responses

Re: change null to 0 in SQL script at 2002-01-03 14:59:08 from Markus Bertheau
Re: change null to 0 in SQL script at 2002-01-03 15:45:38 from Tibor Laszlo
Re: change null to 0 in SQL script at 2002-01-03 16:20:17 from Jason Earl
Re: change null to 0 in SQL script at 2002-01-04 19:52:54 from ThomasR

Browse pgsql-sql by date

	From	Date	Subject
Next Message	rolf.ostvik	2002-01-03 07:39:40	Re: to_char adds leading space, intended?
Previous Message	Aasmund Midttun Godal	2002-01-03 04:31:29	to_char adds leading space, intended?