Re: How can I list the function.
| От | Shoaib Mir |
|---|---|
| Тема | Re: How can I list the function. |
| Дата | |
| Msg-id | bf54be870702010025w5b649dffx6000fa2cdffdcdc1@mail.gmail.com обсуждение исходный текст |
| Ответ на | How can I list the function. ("Harvey, Allan AC" <HarveyA@OneSteel.com>) |
| Ответы |
Re: How can I list the function.
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| Список | pgsql-general |
That actually depends on the nature of function as well. According to the PostgreSQL manual:
CREATE FUNCTION add(integer, integer) RETURNS integer
AS 'select $1 + $2;'
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;
and then doing a
\df+ add
did show me the correct output...
You can also try the following to get the same type of results:
select proargtypes, prorettype, prosrc from pg_proc where proname = 'delete_old';
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )
- \df [ pattern ]
\df+ [ pattern ] Lists available functions, together with their argument and return types. If pattern is specified, only functions whose names match the pattern are shown. If the form \df+ is used, additional information about each function, including language and description, is shown.
Note: To look up functions taking argument or returning values of a specific type, use your pager's search capability to scroll through the \df output.
To reduce clutter, \df does not show data type I/O functions. This is implemented by ignoring functions that accept or return type cstring .
CREATE FUNCTION add(integer, integer) RETURNS integer
AS 'select $1 + $2;'
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;
and then doing a
\df+ add
did show me the correct output...
You can also try the following to get the same type of results:
select proargtypes, prorettype, prosrc from pg_proc where proname = 'delete_old';
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )
On 2/1/07, Harvey, Allan AC <HarveyA@onesteel.com> wrote:
I know the function is there.
What am I doing wrong?
galvdb=#
galvdb=# \df+ delete_old
List of functions
Result data type | Schema | Name | Argument data types | Owner | Language | Source code | Description
------------------+--------+------+---------------------+-------+----------+-------------+-------------
(0 rows)
galvdb=# select delete_old();
delete_old
------------
482
(1 row)
galvdb=# select version();
version
-------------------------------------------------------------------------------------
PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE Linux)
(1 row)
galvdb=#
The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: