Home > mailing lists

Thread: Type of text literals

Type of text literals

From

Steve Baldwin

Date:

11 July 2018, 04:41:23

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' ?

This is pg 10.4 in case it matters.

Thanks,

Steve

Re: Type of text literals

From

Tom Lane

Date:

11 July 2018, 04:54:35

Steve Baldwin <steve.baldwin@gmail.com> 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