Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"
Date
Msg-id 21162.1277833128@sss.pgh.pa.us
Whole thread Raw
In response to Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"  (Marcel Asio <marcel.asio@redbet.com>)
Responses Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"
List pgsql-bugs
Tree view 
Marcel Asio <marcel.asio@redbet.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

pgsql-bugs by date:

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