| From: | "Krasnow, Greg" <gak(at)hnc(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | float8 type |
| Date: | 1998-08-04 16:32:39 |
| Message-ID: | C162BB3549A5CF118D7400805FD412240177C520@pchnc.hnc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is it not possible to have a float8 value default to a negative number??
I tried:
CREATE TABLE TEST1 (T1 FLOAT8 DEFAULT -1);
and I am getting:
ERROR: DEFAULT: type mismatched.
I also tried:
CREATE TABLE TEST1 (T1 FLOAT8 DEFAULT -1.0);
and have the same result.
am I going to have to create a function which returns the negative of a
number since it seems like the parser does not recognize the '-' as a
negative sign?
- Greg
Greg Krasnow
HNC Software Inc.
Financial Solutions Group
Senior Software Engineer
Email: gak(at)hnc(dot)com
Direct Phone: 619.799.8341
Fax: 619.799.8036
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 1998-08-04 17:36:23 | Re: [GENERAL] How can i delete large objects from DB? |
| Previous Message | Sferacarta Software | 1998-08-04 12:54:59 | Re: [GENERAL] default date |