Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mallah(at)trade-india(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ]
Date: 2003-07-23 16:47:43
Message-ID: 13916.1058978863@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<mallah(at)trade-india(dot)com> 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 casting quite right? (For instance,
"timestamp" isn't "timestamp with time zone" ...)

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message mallah 2003-07-23 17:21:16 Re: factoring problem with view in 7.3.3 [ SOLVED ]
Previous Message mallah 2003-07-23 16:37:09 Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ]