Re: Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail

Craig Ringer <craig@postnewspapers.com.au> writes:
>>   - other products are happy to solve the DISTINCT restriction without
>>     any hint as far as what the datatype really is
>
> ... and so is Pg. That's not the problem; Pg complains after resolving the
> SELECT DISTINCT, when it finds that it's trying to insert values of type
> text' into a column with type 'timestamp'.

Ah yes. I've been paying more attention to the energy people have been
willing to put into helping the OP than into what the problem really
is. Thanks for clarifying.

--
dim