| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
| Cc: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Return Record with CASE problem |
| Date: | 2003-06-11 14:05:03 |
| Message-ID: | 20030611070240.C90036-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2003-06-11 14:11:48 | Re: Return Record with CASE problem |
| Previous Message | Stephan Szabo | 2003-06-11 14:02:06 | Re: Options for select from function returning record? |