Re: Return Record with CASE problem

Thanks for the response, Stephan.

I ommitted to say that selecting AS typer varchar doesn't work either.

On 11/06/03, Stephan Szabo (sszabo@megazone23.bigpanda.com) wrote:
>
> 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.
>
>

--
Rory and Barbara Campbell-Lange
Flat 10, 72 Tottenham Court Road, London, W1T 2HE
(m) (0)7939150693 (h) (0)2075805902 (f) (0)2076375880