Re: BUG #5389: Column order on dump/reload broken from defined setof function - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5389: Column order on dump/reload broken from defined setof function
Date
Msg-id 603c8f071003281720x414628dav62f8823605fdd899@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5389: Column order on dump/reload broken from defined setof function  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-bugs
On Fri, Mar 26, 2010 at 7:00 AM, Dimitri Fontaine
<dfontaine@hi-media.com> wrote:
> "Timothy Seever" <tim.seever@gmail.com> writes:
>> CREATE FUNCTION testfunc() RETURNS setof tablec AS $BODY$ SELECT * FROM
>> tablec; $BODY$ LANGUAGE 'sql' STABLE;
>
> Common wisdom saith to never ever use "SELECT *" in your code. You just
> found out a reason why.

Still pretty annoying though.

...Robert

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #5392: Query Optimization
Next
From: Takahiro Itagaki
Date:
Subject: Re: BUG #5394: invalid declspec for PG_MODULE_MAGIC