Request a Demo
Home   >   mailing lists

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

From Tom Lane
Subject Re: "Type does not exist" error when returning array of type in non-public schema
Date
Msg-id 1131306.1738865694@sss.pgh.pa.us
Whole thread Raw
In response to Re: "Type does not exist" error when returning array of type in non-public schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view 
"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 by date:

Previous
From: Jacob Brazeal
Date:
Subject: Re: new commitfest transition guidance
Next
From: Tom Lane
Date:
Subject: Re: new commitfest transition guidance