Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcel Asio <marcel(dot)asio(at)redbet(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"
Date: 2010-06-29 17:38:48
Message-ID: 21162.1277833128@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Marcel Asio <marcel(dot)asio(at)redbet(dot)com> writes:
> Yes I managed to figured that out, but when was this changed?

> It was working in 8.4 but not 9.0 and I could not find anything about this in the release notes.

The 9.0 release notes are not really up to snuff yet :-(. The only
thing in the notes about it is "Allow PL/pgSQL to handle row types with
dropped columns" which is a rather inadequate description of the
consequences of that patch. We're probably going to need to call it out
as an incompatibility.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcel Asio 2010-06-29 19:00:21 Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"
Previous Message Kris Jurka 2010-06-29 16:59:22 Re: [JDBC] JDBC: 2 bugs: Getting a smallint array actually gets an integer array and return type of a boolean array is bit.