Re: Case - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Case
Date
Msg-id Pine.LNX.4.30.0105142237490.757-100000@peter.localdomain
Whole thread Raw
In response to Case  (Cwhisperer <Cwhisperer@vo.lu>)
List pgsql-sql
Cwhisperer writes:

> what's wrong when you receive this message from an select statement
> : CASE types "date" and "text" not matched

You probably did something like

CASE WHEN something THEN date_value ELSE text_value

The data types in the result branches of a case expression need to match.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: "Ligia Pimentel"
Date:
Subject: fatal ERROR running simple join query...
Next
From: Martín Marqués
Date:
Subject: Re: Auto incrementing an integer