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$8f01010a@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.

Regards,
Fernando

In response to

Responses

Browse pgsql-sql by date

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