Re: 7.3.2 vs 7.1.2

On Tue, May 20, 2003 at 06:58:01PM +0300, Victor Yegorov wrote:
>
> Try changing the join above to:
>
> loads l JOIN rcn_details r ON r.id = l.rcn_id
>

Nothing, I mean - the same result.

>
> Also, give the full description of fields, involved in your
> load_rcn_id_idx and rcn_detail_idx indicies.
>

\d load_rcn_id_idx:

Index "public.load_rcn_id_idx"
Column | Type
--------+---------
rcn_id | integer
btree, for table "public.loads"

\d loads:

...
rcn_id | integer | not null default 0
...

\d rcn_detail_idx:

Index "public.rcn_detail_idx"
Column | Type
--------+---------
id | integer
unique, btree, for table "public.rcn_details"

\d rcn_details:

...
id | integer | default nextval('rcn_details_id'::text)
...

\d rcn_details_id

Sequence "public.rcn_details_id"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean

--
Eugene Fokin
SOLVO Ltd. Company