i was able to fix the problem but i still dont know the reason. I
discovered the column objectid in table smb_contacts was int4 and not
int8. obviously all values were less then max(int4) dso there was no
problems in that. However I still need to know why the order by trigger
this to happen. I am j
Objectz wrote:
> Oops .. Here they are
>
>
> =
>
> intranet=# explain analyze SELECT obj.companyid, obj.name,
> obj.description, intranet-# cnt.firstname, cnt.lastname intranet-# FROM
> smb_contacts cnt JOIN shr_objects ob
hi all,
I have a strange problem and really wish to get some help in here.
I have the following tables
create table shr_objects(
objectidint8not null
companyid int4not null
namevarchar(255)
description varchar(255)
)
primary
