John R Pierce <pierce(at)hogranch(dot)com> writes:
> the notation type 'string value' is a native constant in that type,
> while the notation 'string value'::type generates a text constant and
> typecasts it.
Actually, no, there's no difference. If the argument of ::type is
a simple string literal, it's just fed to the type's input parser.
regards, tom lane