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$8f01010a@iptel.com.ar (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group