joshua <jzuellig@arbormetrix.com> writes:
> I'm trying to create an implicit cast from an unknown type into a text array
> type by creating a simple array of size 1. e.g.
> create function textarray(unknown)
> returns text[]
> as 'select ARRAY[$1::text];'
> language sql
> immutable;
> create cast (unknown as text[]) with function textarray(unknown) as
> implicit;
No, that isn't gonna work. "unknown" isn't a real type and the parser
doesn't use normal casting rules for it. It's just a placeholder until
the parser can figure out what type an undecorated literal ought to be.
What's your actual problem? (I don't see how this connects to COPY
at all --- COPY never does any type inference, nor any implicit
casting.)
regards, tom lane