Hiroshi Inoue wrote:
>
> Fernando Nasser wrote:
> >
> > As most things in the SQL standard, you have to collect information
> > from several places and add it together.
> >
> > Look at 4.20, 11.1 and specially at the rules for
> > <schema qualified name>.
> >
> > Then think a little bit about scenarios, trying to apply the rules.
> >
> > It is a pain, but there is no other way.
>
> I couldn't find the description CURRENT_SCHEMA == CURRENT_USER.
> If I recognize SQL99 correctly, the CURRENT schema is the schema
> defined in a <SQL-client module> not restricted to the CURRENT
> user.
>
Yes, but we don't have a "module" language. You have to look for
"session".
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
