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? |