Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 12325 invoked from network); 16 Oct 2008 02:38:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Oct 2008 02:38:16 -0000 Received: (qmail 84163 invoked by uid 500); 16 Oct 2008 02:38:17 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 84136 invoked by uid 500); 16 Oct 2008 02:38:16 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 84125 invoked by uid 99); 16 Oct 2008 02:38:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Oct 2008 19:38:16 -0700 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Oct 2008 02:37:08 +0000 Received: from fe-emea-10.sun.com (gmp-eb-lb-1-fe3.eu.sun.com [192.18.6.10]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m9G2bXNJ022501 for ; Thu, 16 Oct 2008 02:37:44 GMT Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K8T00C018DID300@fe-emea-10.sun.com> (original mail from Dag.Wanvik@Sun.COM) for derby-user@db.apache.org; Thu, 16 Oct 2008 03:37:33 +0100 (BST) Received: from khepri23.norway.sun.com ([129.159.112.235]) by fe-emea-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K8T00GCW8ML8K10@fe-emea-10.sun.com> for derby-user@db.apache.org; Thu, 16 Oct 2008 03:37:33 +0100 (BST) Date: Thu, 16 Oct 2008 04:37:32 +0200 From: Dag.Wanvik@Sun.COM (Dag H. Wanvik) Subject: Re: How to store values that might be given in different measurement units? In-reply-to: <3e420d300810150358u571bd4eepe1349dec32dadb12@mail.gmail.com> Sender: Dag.Wanvik@Sun.COM To: Derby Discussion Message-id: MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT References: <3e420d300810150358u571bd4eepe1349dec32dadb12@mail.gmail.com> User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org For the next release, a generated columns feature is being worked on. When that gets added, one could get both a way to store the original data, as well as a generated column with a converted (canonical unit) measure (and not risk losing precision of original data) for which sorting could be applied. Dag