Re: change null to 0 in SQL script

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Karl Raven <lcaasia(at)pd(dot)jaring(dot)my>
Cc: postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: change null to 0 in SQL script
Date: 2002-01-03 14:59:08
Message-ID: 1010069949.19970.22.camel@entwicklung01.cenes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 2002-01-03 at 06:00, Karl Raven wrote:
>
> 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?

What did you try?

Markus Bertheau

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-01-03 15:11:10 Re: OUTER JOIN doesn't work on pgSQL 7.1.2
Previous Message rolf.ostvik 2002-01-03 07:39:40 Re: to_char adds leading space, intended?