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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
