EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Error insert  XML

Forum Index » Standard Server
Author Message
hariszie

New member

Joined: 2 Feb 2012 05:04:39
Messages: 1
Offline

i have problem while insert data in the table.
i have function to copy data between 2 table, like table A to table B. but when i am run this function, data table B not match with table A.
example, i have record in table A with value 1.73 but value will change in table B to 2.00, why? i have used round function to get this record but is not work.
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 452
Offline

If you are using round function, then it make sense. round function will round 1.75 to 2
postgres=# select round(1.75)
postgres-# ;
round
-------
2
(1 row)

If issue is something else, then please share sample test case. So, that I can look into it.

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
 
Forum Index » Standard Server
Go to:   
Powered by JForum 2.1.8 © JForum Team