On Fri, Mar 26, 2010 at 7:00 AM, Dimitri Fontaine
wrote:
> "Timothy Seever" 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
"Timothy Seever" 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
--
Sent via pgsql-bugs mailing list (pgsql
"Timothy Seever" writes:
> Adding a column to an inherited table in-place works as expected with the
> combined table/etc. However on dump/reload the physical order changes, so
> any? predefined select from a setof function pulling from the combined table
> will result in a mismatch.
Yup. This
