Re: "Type does not exist" error when returning array of type in non-public schema

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Type does not exist" error when returning array of type in non-public schema
Дата
Msg-id 1131306.1738865694@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "Type does not exist" error when returning array of type in non-public schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Feb 6, 2025 at 9:47 AM Chris Cleveland <ccleveland@dieselpoint.com>
> wrote:
>> RETURN "rdb.Token"[], RETURN "rdb.Token[]" all fail.

> Expecting these two to work suggests you need to re-read the section on how
> quoting identifiers works.

I'm wondering if it needs to be "Token".  Mixed-case SQL identifiers
are usually more of a pain than they're worth, frankly.

            regards, tom lane



В списке pgsql-hackers по дате отправления: