From: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Return Record with CASE problem |
Date: | 2003-06-11 14:11:48 |
Message-ID: | 20030611141148.GB24912@campbell-lange.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)megazone23(dot)bigpanda(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Network Administrator | 2003-06-11 14:17:47 | Re: [GENERAL] MySQL gets $19.5 MM |
Previous Message | Stephan Szabo | 2003-06-11 14:05:03 | Re: Return Record with CASE problem |