Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g03ExLm41388 for ; Thu, 3 Jan 2002 09:59:23 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD90557E8.dip.t-dialin.net [217.5.87.232]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id g03F3J612571; Thu, 3 Jan 2002 16:03:20 +0100 Subject: Re: change null to 0 in SQL script From: Markus Bertheau To: Karl Raven Cc: postgres sql list In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-84nUnz8bf6Fep4Du5+ZN" X-Mailer: Evolution/1.0 (Preview Release) Date: 03 Jan 2002 15:59:08 +0100 Message-Id: <1010069949.19970.22.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200201/15 X-Sequence-Number: 6106 --=-84nUnz8bf6Fep4Du5+ZN Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Thu, 2002-01-03 at 06:00, Karl Raven wrote: >=20 > I like to change a null value of a query to 0 in the SQL script. I know h= ow > to do it in MS-SQL server and MS-Access but those commands does not work = in > pg-sql. >=20 > Anyone has any ideas? What did you try? Markus Bertheau --=-84nUnz8bf6Fep4Du5+ZN Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA8NHG8KNEjAb345r4RArxHAJ0dUp5DLW1JtF9jOOIFU08dQgHEZgCdGm6x YFljDm2guf0A96eCseiMEqg= =/vkb -----END PGP SIGNATURE----- --=-84nUnz8bf6Fep4Du5+ZN--