From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, "Krasnow, Greg" <gak(at)hnc(dot)com> |
Subject: | Re: [GENERAL] float8 type |
Date: | 1998-08-05 08:58:26 |
Message-ID: | 8457.980805@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Krasnow,,
martedì, 4 agosto 98, you wrote:
KG> Is it not possible to have a float8 value default to a negative number??
KG> I tried:
KG> CREATE TABLE TEST1 (T1 FLOAT8 DEFAULT -1);
KG> and I am getting:
KG> ERROR: DEFAULT: type mismatched.
KG> I also tried:
KG> CREATE TABLE TEST1 (T1 FLOAT8 DEFAULT -1.0);
KG> and have the same result.
KG> am I going to have to create a function which returns the negative of a
KG> number since it seems like the parser does not recognize the '-' as a
KG> negative sign?
KG> - Greg
KG> Greg Krasnow
KG> HNC Software Inc.
KG> Financial Solutions Group
KG> Senior Software Engineer
KG> Email: gak(at)hnc(dot)com
KG> Direct Phone: 619.799.8341
KG> Fax: 619.799.8036
Try this:
CREATE TABLE TEST1 (T1 FLOAT8 DEFAULT '-1')
^^^^^
Best regards,
Jose' mailto:sferac(at)bo(dot)nettuno(dot)it
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Mchale | 1998-08-05 09:38:00 | PostGres libs/bin for HP-UX 9.05 |
Previous Message | sohomagazine | 1998-08-05 07:07:17 | Small Business/Home Office Magazine At No Cost |