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. Well here's my proposal. 1) Use the different search path for table name and others. 2) Allow only one schema other than temp or catalog in the table name search path so that we can call it the CURRENT schema. Comments ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
