From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Postgresql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Return Record with CASE problem |
Date: | 2003-06-11 15:17:12 |
Message-ID: | 3EE747F8.6050704@cvc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What's this 'typer'? I see you guys using it, so it's NOT a misspell of 'type'?
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(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.
>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2003-06-11 15:29:50 | Re: Postgres performance comments from a MySQL user |
Previous Message | Kaarel | 2003-06-11 15:10:57 | Re: Multilple email being delivered |