Re: empty view, replace view, column type change? - Mailing list pgsql-sql

On Thu, 2005-06-23 at 22:27 +0200, Markus Bertheau wrote:
> Dnia 23-06-2005, czw o godzinie 16:19 -0400, Rod Taylor napisał(a):
> 
> > The data types are different, as one has the timestamp to (6) decimal
> > places after seconds.
> 
> That's strange. I explicitly specified ::TIMESTAMP on both the view and
> the table. Is that not unambiguous?

LOCALTIMESTAMP is probably more specific, so it folds the length in.

If you SELECT 'abc'::varchar(6)::varchar, the end type is varchar(6).

Cast them both to timestamp(N) and what you're trying to do should work.

--