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