Re: structure of query does not match error during RETURN QUERY.

How do you call this function from your code?

Does it work when you call it from PGAdmin?

select  * from cerber.cerber_account_select (1);

Michal Szymanski wrote:
> Hi,
> We call DB procedure that select rows with given ID it works as simple
> SELECT but for future changes we implement as DB procedure (look below
> for DB listing). Recently we modified columns in table
> cerber.cerber_accoun and after this modification procedure does not
> work anymore and it returns
> 42804: structure of query does not match
> It is very strange because we return row of cerber_account in variable
> defined as row of cerber_account.
> We have tried to restart database but it does not help. Probably
> information about old table structure is somewhere cached.
>
> CREATE OR REPLACE FUNCTION cerber.cerber_account_select
> (i_cerber_account_id bigint)
>   RETURNS SETOF cerber.cerber_account AS
> $BODY$
> DECLARE
>     v_result cerber.cerber_account%ROWTYPE;
> BEGIN
>     RETURN QUERY SELECT * FROM cerber.cerber_account WHERE
> cerber_account_id=i_cerber_account_id;
>     RETURN;
> END;
> $BODY$
>   LANGUAGE 'plpgsql' VOLATILE
>   COST 100
>   ROWS 1000;
>
>
> Michal Szymankis
> http://blog.szymanskich.net
>
>