Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: evaluating equation stored in a string
- From: Alban Hertroys <alban(at)magproductions(dot)nl>
- To: SunWuKung <Balazs(dot)Klein(at)t-online(dot)hu>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: evaluating equation stored in a string
- Date: Wed, 26 Apr 2006 18:05:45 +0200
- Message-id: <444F9A59(dot)6000108(at)magproductions(dot)nl>
SunWuKung wrote:
However I have a problem with this cast. I don't know how to handle brackets in the equation, since SELECT 35/124 ::numeric --0.28.... while SELECT (35/124) ::numeric -- 0
The brackets aren't your problem, your numbers aren't as accurate as the result you require. An eval() function would give the same results. You'll want this instead:
SQL> select (35.0/124.0)::numeric;
numeric
------------------------
0.28225806451612903226
Regards,
--
Alban Hertroys
alban(at)magproductions(dot)nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
- References:
- evaluating equation stored in a string
- From: SunWuKung
- evaluating equation stored in a string
- Prev by Date: Re: Ordering of records in group by not possible
- Next by Date: Re: Ordering of records in group by not possible
- Previous by thread: Re: evaluating equation stored in a string
- Next by thread: pg_dump -t <> pg_restore -t
- Indexes: