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

From Dimitri Fontaine
Subject Re: BUG #5389: Column order on dump/reload broken from defined setof function
Date
Msg-id 87tys39wkf.fsf@hi-media-techno.com
Whole thread Raw
In response to BUG #5389: Column order on dump/reload broken from defined setof function  ("Timothy Seever" <tim.seever@gmail.com>)
Responses Re: BUG #5389: Column order on dump/reload broken from defined setof function  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
"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.

Regards,
--
dim

pgsql-bugs by date:

Previous
From: Martin Schäfer
Date:
Subject: Re: UTF-8 encoding failure
Next
From: "sachin"
Date:
Subject: BUG #5392: Query Optimization