On Tue, 26 Jun 2001, Itzinger, Oskar wrote:
> In PostgreSQL 7.1.2, I'm experimenting with the following two cases (all
> referred to non-temporary tables exist in the current database):
>
> =
>
> 1.
>
> CREATE TEMPORARY TABLE tmp (
> col1 TEXT,
> col2 TEXT,
> col3 TEXT,
> col4
"Itzinger, Oskar" <[EMAIL PROTECTED]> writes:
> 1. What exactly is the type of colx in Case 1?
> 2. Why can't PostgreSQL infer that very same type for colx in Case 2?
The || operator is known to yield a result of type "text". But when the
sum total of the known information is
'' AS colx