Marc Munro <[EMAIL PROTECTED]> writes:
> This works fine:
> "str2"varchar(40)
> This does not:
> "str2""pg_catalog"."varchar"(40)
Yeah. That's because in all existing PG releases, type modifiers are
handled by hard-wired grammar productions that *only* work
On Tue, 2007-11-12 at 19:32 -0500, Tom Lane wrote:
> Marc Munro <[EMAIL PROTECTED]> writes:
> > This works fine:
> > "str2"varchar(40)
> > This does not:
> > "str2""pg_catalog"."varchar"(40)
>
> Yeah. That's because in all existing PG releases, type modifie
It seems that in create table I cannot specify the schema of a built-in
type that has a length specifier. Nor can I double-quote the type name.
Is this correct/expected behaviour, and are there work-arounds?
This works fine:
create table "public"."additional" (
"str1""pg_catalo