Re: CASE WHEN propagating two columns in a SELECT

On Aug 16, 8:23 am, Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de> wrote:
> Hi all,
>
> is there a way to propagate two columns with a CASE WHEN
> statement in a SELECT. What I tried and I think it shows
> what I want to do is:
>
> SELECT
> CASE
> WHEN TASK_ID > 1 THEN (1,'green')
> ELSE (0,'red')
> END AS (COL_A, COLOR)
> FROM
> TEST_TABLE
What I've used before is:

SELECT
CASE
   WHEN task_id > 1 THEN some_object_type(1,'green')    ELSE some_object_type(0,'red')
END AS whatever
FROM test_table

giving an object instance from which you can get whatever.attribute1 and whatever.attribute2 in an enclosing query. Received on Thu Aug 16 2007 - 17:48:33 CDT