Re: Return Record with CASE problem

On Wed, 11 Jun 2003, Rory Campbell-Lange wrote:

> Selecting on this function works fine when I don't use the CASE column
> 'typer' in my select and don't include it in the returned 'resulter' in
> the function. 'typer'  is a int2, while the output is a varchar. How can
> I get to "typer" in my select?
>
> Failed select:
>
> temporary=> SELECT
>                 *
>             FROM
>                 fn_v1_board_view_board (1, 1)
>             AS (n_id integer, t_description varchar, t_name varchar,
>                 typer integer, n_id_photo integer);

I think that should probably be typer varchar since that's what you seem
to actually be returning.