| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Henry <hensa22(at)yahoo(dot)es> |
| Cc: | Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy>, ricardo yanguma <ricardo(dot)yanguma(at)gmail(dot)com>, postgresayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: como dividir? |
| Date: | 2008-01-31 11:49:23 |
| Message-ID: | 20080131114922.GA5145@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Algo que no se ha comentado es la precisión del resultado. Considera
alvherre=# select 1::float/7;
?column?
-------------------
0.142857142857143
(1 row)
alvherre=# select 1::float8/7;
?column?
-------------------
0.142857142857143
(1 row)
alvherre=# select 1::numeric/7;
?column?
------------------------
0.14285714285714285714
(1 row)
alvherre=# select 1::numeric(44,42)/7;
?column?
----------------------------------------------
0.142857142857142857142857142857142857142857
(1 row)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toni Casueps | 2008-01-31 11:51:11 | duda de expresiones regulares |
| Previous Message | Henry | 2008-01-31 11:41:36 | Re: como dividir? |