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, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group