Skip site navigation (1) Skip section navigation (2)

Re: Pls Hlp: SQL Problem

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: "'Scott Marlowe'" <scott(dot)marlowe(at)gmail(dot)com>,"'Hengky Lie'" <hengkyliwandouw(at)gmail(dot)com>
Cc: "'pgsql-sql'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Pls Hlp: SQL Problem
Date: 2008-09-12 22:01:56
Message-ID: 00e901c91523$2c633e70$ (view raw or whole thread)
Lists: pgsql-sql

> -----Mensaje original-----
> De: pgsql-sql-owner(at)postgresql(dot)org 
> [mailto:pgsql-sql-owner(at)postgresql(dot)org] En nombre de Scott Marlowe
> On Fri, Sep 12, 2008 at 12:50 PM, Hengky Lie 
> <hengkyliwandouw(at)gmail(dot)com> wrote:
> > Dear Richard,
> >
> Put parens around the whole thing, like:
> (tbltransaksi.hargapokok * tbltransaksi.keluar)::numeric(2,0) AS modal

Consider that if you are NOT going to use the decimals you should really use
integer or bigint datatypes. The numeric type compute much slower than
integer datatypes.


In response to


pgsql-sql by date

Next:From: Scott MarloweDate: 2008-09-12 23:50:19
Subject: Re: Pls Hlp: SQL Problem
Previous:From: Scott MarloweDate: 2008-09-12 20:07:53
Subject: Re: Doubts about FK

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group