Re: [gnome-db] Congratulations to you all -> PostgreSQL 7.3 questions

[Rodrigo Moya <rodrigo gnome-db org>]

On Fri, 2002-12-13 at 14:12, Jean-Michel POURE wrote:
> Le Vendredi 13 Décembre 2002 13:58, Rodrigo Moya a écrit :
> > "name, unique id, owner, comments, return type, number of arguments,
> > arguments types (arguments types in the order, separated by spaces) and SQL
> > definition. For the arguments where any type is accepted, '-' is returned
> > as type."
> 
> Dear Rodrigo,
> 
> Oracle supports language cartriges, PostgreSQL has several built-in languages, 
> etc... It seems like the schema should also return the name of the procedural 
> language for the function.
> 
right, so what about adding a "language" field in the schema, and rename
the "SQL" one to "Source"? Thus, we can return the source code for any
language.

> Also, PostgreSQL & Oracle functions can have access privileges like a table or 
> a view.
> 
yes. Maybe that belongs more to the yet-to-come GRANT/REVOKE API, or
even have a new schema for PRIVILEGES.

cheers