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: [EMAIL PROTECTED] 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org