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