Re: What's the CURRENT schema ?

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