#
# Testing CONCAT with null values
#

SET sql_mode=ORACLE;

EXPLAIN EXTENDED SELECT 'a'||'b'||'c';
EXPLAIN EXTENDED SELECT CONCAT('a'||'b'||'c');

SELECT ''   || '';
SELECT ''   || 'b';
SELECT ''   || NULL;
SELECT 'a'  || '';
SELECT 'a'  || 'b';
SELECT 'a'  || NULL;
SELECT NULL || '';
SELECT NULL || 'b';
SELECT NULL || NULL;

SELECT ''   || ''    || '';
SELECT ''   || ''    || 'c';
SELECT ''   || ''    || NULL;
SELECT ''   || 'b'   || '';
SELECT ''   || 'b'   || 'c';
SELECT ''   || 'b'   || NULL;
SELECT ''   || NULL  || '';
SELECT ''   || NULL  || 'c';
SELECT ''   || NULL Empathic understanding: a review of the concept and some theoretical considerations.
A review of the psychoanalytic literature shows that empathy has always played an important part in the practice of psychoanalysis, but that as a concept it has not been well understood. This confusion and a certain mistrust of empathy that it engenders were traced to an incomplete understanding of the meaning of the term, and to the lack of an affect theory that could explain the communication involved in the empathic process. These problems were examined and suggestions for their resolution were made. A line of affective development that culminated in empathic understanding was proposed. An operational approach to empathy was described and the role of empathy as the basis for and the prelude to psychoanalytic interpretation was