Re: Return Record with CASE problem - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Return Record with CASE problem
Date
Msg-id 20030611092712.R93562-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Return Record with CASE problem  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Wed, 11 Jun 2003, Dennis Gearon wrote:

> What's this 'typer'? I see you guys using it, so it's NOT a misspell of 'type'?

It's a "column" name for the output of the function return.

> Rory Campbell-Lange wrote:
>
> > 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.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Options for select from function returning record?
Next
From: "Nigel J. Andrews"
Date:
Subject: plpgsql, rowtype and dropped columns