Yep!
it works perfectly now.
CREATE or replace VIEW sent_enquiry_eyp_iid_ip_cat2 as ((SELECT
eyp_rfi.rfi_id, eyp_rfi.sender_uid, eyp_rfi.receiver_uid, eyp_rfi.subject,
cast(eyp_rfi.generated as timestamp with time zone ) FROM ONLY eyp_rfi)
UNION (SELECT iid_rfi.rfi_id, iid_rfi.sender_uid, i
<[EMAIL PROTECTED]> writes:
> the column 'generated' was timestamp in 2 place and date in 2 place,
> i wanted it in my and did a typecasting in the view below
> but it suffers from the same problem .
AFAIR it should work if you insert casts into the UNION's member selects.
Maybe you didn't get the
> Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
>> I have a view which is a union of select of certain feilds from
>> indentical tables. The problem is when we query a column on
>> which index exists exists foreach of the tables does not use the
>> indexes.
>
> Hard to be certain since you didn't
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> I have a view which is a union of select of certain feilds from
> indentical tables. The problem is when we query a column on
> which index exists exists foreach of the tables does not use the
> indexes.
Hard to be certain since you didn't show us
On Wednesday 23 July 2003 11:21, Rajesh Kumar Mallah wrote:
> Hi ,
>
> I have a view which is a union of select of certain feilds from
> indentical tables. The problem is when we query a column on
> which index exists exists foreach of the tables does not use the
> indexes.
>
>
> But when we query
Hi ,
I have a view which is a union of select of certain feilds from
indentical tables. The problem is when we query a column on
which index exists exists foreach of the tables does not use the
indexes.
But when we query individual tables it uses indexes.
Regds
Mallah.
tradein_clients=# crea
