Re: ERROR: table row type and query-specified row type do not match - Mailing list pgsql-general

Patryk Kordylewski wrote:
> Hi Tom,
>
> we are running PostgreSQL 8.2.4.
>
> Tom Lane wrote:
>> Patryk Kordylewski <pk@imos.net> writes:
>>> can someone help/explain me why i get this error when i try to make
>>> an update on that view? It seems that something is wrong with the
>>> subselect.
>>> http://fooby.imosnet.de/error.txt
>>
>> AFAICT, this works for me, so either you left something important out of
>> your example or you're looking at an already-fixed bug.  What PG version
>> is that?
>>
>>             regards, tom lane
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>>                http://www.postgresql.org/docs/faq
>>

I made a test-case which is not working for me. Perhaps something wrong
with the SELECT DISTINCT ON () syntax when i specify more then 1 column?

At first this was working when i specified only one column in the SELECT
DISTINCT ON-clause, then i inserted a dummy column "second_distinct" and
put it into the clause and it's not working anymore.

PG Version: 8.2.4

http://fooby.imosnet.de/not_working.txt

Thanks for help,
Patryk