Re: getpid() function

On Thu, Aug 01, 2002 at 01:41:49PM -0400, Bruce Momjian wrote:
>
> Added to TODO:
>
> * Consistently name server-side internal functions

OK, good start of discussion is define groups of the PostgreSQL
functions:

1/ Extern compatible functions

The functions compatible with standards or customs
or others SQL servers. For example trim, to_char, ...

2/ PostgreSQL specific functions used in standard SQL operations

(the function works with standard data and not load it from
internal PostgreSQL stuff).

For example convert(), all datetype function like int(). The name
convenition must be like names in group 1/

3/ PostgreSQL specific system functions

For example pg_backend_pid(). IMHO clean solution is
use "pg_" prefix.

4/ The calls without '( )'

For example "SELECT current_user;" IMHO right is not use
"pg_" prefix _if_ you call it without braces. _But_ if you call
it with '()' and function can be member of group 3/ is right use
"pg_" prefix.

For example:
SELECT current_user;
SELECT pg_current_user();

5/ Deprecated functions

In docs marked as "deprecated" and will removed in some major
release (for example in 8.0).

6/ ???

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz