X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 2877B30EF87 for ; Mon, 16 Jun 2003 22:01:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 39527-03 for ; Mon, 16 Jun 2003 19:01:12 -0300 (ADT) Received: from relay1.san1.aens.net (relay1.san1.aens.net [192.215.81.74]) by svr1.postgresql.org (Postfix) with ESMTP id 6E52D30D1CE for ; Mon, 16 Jun 2003 19:01:09 -0300 (ADT) Received: from mail.pcgus.com (mail.pcgus.com [12.45.242.4]) by relay1.san1.aens.net (8.11.6/8.9.3) with ESMTP id h5GM18W04483 for ; Mon, 16 Jun 2003 22:01:09 GMT Received: from pcgssu2.pcgus.com ([10.8.2.5]) by mail.pcgus.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 2DF62KWN; Mon, 16 Jun 2003 17:52:21 -0400 Received: by PCGSSU2 with Internet Mail Service (5.5.2653.19) id ; Mon, 16 Jun 2003 17:02:34 -0500 Message-ID: From: "Bu, Ning" To: "'pgsql-sql@postgresql.org'" Subject: set decimal point in SQL Date: Mon, 16 Jun 2003 17:02:34 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/related; boundary="----_=_NextPart_000_01C33452.FD8350B0"; type="multipart/alternative" X-Spam-Status: No, hits=1.7 tagged_above=0.0 required=5.0 tests=EXTRA_MPART_TYPE, HTML_80_90, HTML_FONT_COLOR_BLUE, HTML_FONT_FACE_ODD X-Spam-Level: ** X-Archive-Number: 200306/222 X-Sequence-Number: 13980 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C33452.FD8350B0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C33452.FD8350B0" ------_=_NextPart_001_01C33452.FD8350B0 Content-Type: text/plain; charset="iso-8859-1" I have a field set up as money and I try to calculate some number and put in this field, but the number will be 6 demical point and I want to cut it to only 2-4 decimal point, how can I do it? Thanks ------_=_NextPart_001_01C33452.FD8350B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I have a fi= eld set up as money and I try to calculate some number and put in this field, b= ut the number will be 6 demical point and I want to cut it to only 2-4 decimal point, how can I do it? Thanks

------_=_NextPart_001_01C33452.FD8350B0-- ------_=_NextPart_000_01C33452.FD8350B0 Content-Type: image/jpeg; name="image001.jpg" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="image001.jpg" Content-ID: /9j/4AAQSkZJRgABAgEASABIAAD/7QSyUGhvdG9zaG9wIDMuMAA4QklNA+kA AAAAAHgAAwAAAEgASAAAAAADBgJS//f/9wMPAlsDRwUoA/wAAgAAAEgASAAA AAAC2AIoAAEAAABkAAAAAQADAwMAAAABJw8AAQABAAAAAAAAAAAAAAAAYAgA GQGQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4QklNA+0AAAAA ABAASAAAAAEAAQBIAAAAAQABOEJJTQPzAAAAAAAIAAAAAAAAAAA4QklNBAoA AAAAAAEAADhCSU0nEAAAAAAACgABAAAAAAAAAAI4QklNA/UAAAAAAEgAL2Zm AAEAbGZmAAYAAAAAAAEAL2ZmAAEAoZmaAAYAAAAAAAEAMgAAAAEAWgAAAAYA AAAAAAEANQAAAAEALQAAAAYAAAAAAAE4QklNA/gAAAAAAHAAAP////////// //////////////////8D6AAAAAD/////////////////////////////A+gA AAAA/////////////////////////////wPoAAAAAP////////////////// //////////8D6AAAOEJJTQQAAAAAAAACAAA4QklNBAIAAAAAAAIAADhCSU0E CAAAAAAAEAAAAAEAAAJAAAACQAAAAAA4QklNBAkAAAAAAqIAAAABAAAAgAAA AAIAAAGAAAADAAAAAoYAGAAB/9j/4AAQSkZJRgABAgEASABIAAD//gAnRmls ZSB3cml0dGVuIGJ5IEFkb2JlIFBob3Rvc2hvcKggNC4wAP/uAA5BZG9iZQBk gAAAAAH/2wCEAAwICAgJCAwJCQwRCwoLERUPDAwPFRgTExUTExgRDAwMDAwM EQwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwBDQsLDQ4NEA4OEBQODg4U FA4ODg4UEQwMDAwMEREMDAwMDAwRDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM DAwMDP/AABEIAAIAgAMBIgACEQEDEQH/3QAEAAj/xAE/AAABBQEBAQEBAQAA AAAAAAADAAECBAUGBwgJCgsBAAEFAQEBAQEBAAAAAAAAAAEAAgMEBQYHCAkK CxAAAQQBAwIEAgUHBggFAwwzAQACEQMEIRIxBUFRYRMicYEyBhSRobFCIyQV UsFiMzRygtFDByWSU/Dh8WNzNRaisoMmRJNUZEXCo3Q2F9JV4mXys4TD03Xj 80YnlKSFtJXE1OT0pbXF1eX1VmZ2hpamtsbW5vY3R1dnd4eXp7fH1+f3EQAC AgECBAQDBAUGBwcGBTUBAAIRAyExEgRBUWFxIhMFMoGRFKGxQiPBUtHwMyRi 4XKCkkNTFWNzNPElBhaisoMHJjXC0kSTVKMXZEVVNnRl4vKzhMPTdePzRpSk hbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2JzdHV2d3h5ent8f/2gAMAwEAAhED EQA/APROif0Kv6X81T9Lj+ar/m/5K0F8rJJIfqlJfKySKn6pSXyskkp+qUl8 rJJKfqlJfKySSn6pSXyskkp+qUl8rJJKfqlJfKySSn//2ThCSU0EBgAAAAAA BwABAAAAAQEA//4AJ0ZpbGUgd3JpdHRlbiBieSBBZG9iZSBQaG90b3Nob3Co IDQuMAD/7gAOQWRvYmUAZIAAAAAB/9sAhAAMCAgNCQ0VDAwVGhQQFBogGxoa GyAiFxcXFxciEQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM AQ0NDREOERsRERsUDg4OFBQODg4OFBEMDAwMDBERDAwMDAwMEQwMDAwMDAwM DAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAAYBaADASIAAhEBAxEB/90ABABa /8QBPwAAAQUBAQEBAQEAAAAAAAAAAwABAgQFBgcICQoLAQABBQEBAQEBAQAA AAAAAAABAAIDBAUGBwgJCgsQAAEEAQMCBAIFBwYIBQMMMwEAAhEDBCESMQVB UWETInGBMgYUkaGxQiMkFVLBYjM0coLRQwclklPw4fFjczUWorKDJkSTVGRF wqN0NhfSVeJl8rOEw9N14/NGJ5SkhbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2 N0dXZ3eHl6e3x9fn9xEAAgIBAgQEAwQFBgcHBgU1AQACEQMhMRIEQVFhcSIT BTKBkRShsUIjwVLR8DMkYuFygpJDUxVjczTxJQYWorKDByY1wtJEk1SjF2RF VTZ0ZeLys4TD03Xj80aUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9ic3R1dn d4eXp7fH/9oADAMBAAIRAxEAPwCv0T+n4/8AxrP+qavW15J0U/r+P/xrP+qa vWg8eKElsWSHZfXWYe4A+ZUMjIFTJBE/Fc1kXbg63mJP+amk0uesGqdc19Su p2ZrLmWGQxwLR4B35v8A0V0qKlJJJIqUkkkkpSSSSSlJJJJKUkkkkpSSSSSl JJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkk kpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJ JJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkk pSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJ JJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkp SSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJ JKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpS SSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSn/0J9G6oKn04zKKXOdYA6x 7d1kOP8Ag/3Hs/MXY/sOl/0hYfCT/wCQavnZJArQ/S1HTXVN21+weYa7/vqz croeQ+Q3XcYOn/mbF89pIaJfpboXRK+k1uDQPUsILyONPotZ/JatRfKqSSX6 qSXyqkip+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp +qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl 8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6 qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp +qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl 8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn/2Q== ------_=_NextPart_000_01C33452.FD8350B0--