Re: Type of text literals

Steve Baldwin <[email protected]> writes:
> Can someone please help me understand this:

> b2bc_dev=# select pg_typeof('a') as a, pg_typeof(array['a']) as arr;
>     a    |  arr
> ---------+--------
>  unknown | text[]
> (1 row)

> Why is a text literal on its own 'unknown' whereas in the context of an
> array it assumes 'text' ?

There is no "unknown[]" type, so it has to assume something.

			regards, tom lane