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

From Dimitri Fontaine
Subject Re: Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail
Date
Msg-id 87aar7b6e6.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Dean Rasheed
Date:
Subject: Invalid YAML output from EXPLAIN
Next
From: Farid Zidan
Date:
Subject: Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail