]
297 St-Paul, West - Montreal, Quebec, Canada - H2Y 2A5
Phone: 514-282-7073 ext: 371 - Fax: 514-282-8011
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]]
Sent: July 16, 2002 14:52
To: Alain Lavigne
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Need help on a troublesome query
On Tue, 16 Jul 2002, Alain Lavigne wrote:
> Thanks that worked, but why does that happen or maybe you could point
> to the proper thread so I read up on it.
It's an issue that the numeric constant gets cast to int4 somewhat
prematurely. I don't have a pointer to a thread off hand, but if you
se
On Tue, 16 Jul 2002, Alain Lavigne wrote:
> Index "bld_x1_tb_bus_fact"
> Column | Type
> -+---
> party_id| bigint
> bus_fact_typ_cd | character(10)
> cont_id | bigint
> btree
>
> With the following query on 5 records:
>
> expla
On PostgreSQL Version 7.2.1 on Redhat Linux 7.1
Table bld_tb_bus_fact definition
Column | Type | Modifiers
-+-- +---
bus_fact_id| bigint| not nu
