> -Mensaje original-
> De: Scott Marlowe [mailto:[EMAIL PROTECTED]
> >
> > 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.
>
> Note that if you're just c
On Mon, Sep 15, 2008 at 2:14 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote:
>
>
>> -Mensaje original-
>> De: Scott Marlowe [mailto:[EMAIL PROTECTED]
>
>> >
>> > Consider that if you are NOT going to use the decimals you should
>> > really use integer or bigint datatypes. The numeric type
>>
On Fri, Sep 12, 2008 at 4:01 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote:
>
>
>> -Mensaje original-
>> De: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] En nombre de Scott Marlowe
>>
>> On Fri, Sep 12, 2008 at 12:50 PM, Hengky Lie
>> <[EMAIL PROTECTED]> wrote:
>> > Dear Richard,
>> >
>>
>
> -Mensaje original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] En nombre de Scott Marlowe
>
> On Fri, Sep 12, 2008 at 12:50 PM, Hengky Lie
> <[EMAIL PROTECTED]> wrote:
> > Dear Richard,
> >
>
> Put parens around the whole thing, like:
>
> (tbltransaksi.hargapokok * tbltran
On Fri, Sep 12, 2008 at 12:50 PM, Hengky Lie <[EMAIL PROTECTED]> wrote:
> Dear Richard,
>
> Sorry for that :) and thanks for your tips, but it didn't solve my problem.
> Maybe because my postgresql knowledge limitation. I have tried your
> suggestion, my view like this :
Put parens around the whol
Dear Richard,
Sorry for that :) and thanks for your tips, but it didn't solve my
problem. Maybe because my postgresql knowledge limitation. I have tried
your suggestion, my view like this :
-- View: "vwlapjual"
-- DROP VIEW vwlapjual;
CREATE OR REPLACE VIEW vwlapjual AS
SELECT tblpenjuala
Hengky Lie wrote:
> Dear friends,
Hello. Quick tip - don't reply to another message when starting a new
thread, people will assume it's part of the old thread.
[snip most of query]
> / 100::numeric *
> Food";3960.;*4200.*;*240.*
> Why the ca
Dear friends,
I have problem in postgresql view. This is the view (Pay attention to
the red and blue colours):
SELECT tblpenjualan.tanggal, tblpenjualan."operator",
tblpenjualan.noinvoice, tblpenjualan.bayar, tblpenjualan.bayarvocher,
tblpenjualan.jam, tblpenjualan.id, tblpenjualan.jeniscar