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.
--