Re: [GENERAL] How can I list the function. SOLVED

2007-02-01 Thread Harvey, Allan AC
Thank you all, > I know the function is there. > What am I doing wrong? Talking to a 8.2.0 server with a 7.4.5 client. Sorry for the noise, I sometimes get lost on which versions I have where of this wonderful software. Allan The material contained in this email may be confidential, privileged

Re: [GENERAL] How can I list the function.

2007-02-01 Thread Tom Lane
"Shoaib Mir" <[EMAIL PROTECTED]> writes: > On 2/1/07, Harvey, Allan AC <[EMAIL PROTECTED]> wrote: >> I know the function is there. >> What am I doing wrong? > To reduce clutter, \df does not show data type I/O functions. This is > implemented by ignoring functions that accept or return type cstrin

Re: [GENERAL] How can I list the function.

2007-02-01 Thread Adrian Klaver
On Wednesday 31 January 2007 8:46 pm, Harvey, Allan AC 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

Re: [GENERAL] How can I list the function.

2007-02-01 Thread Shoaib Mir
That actually depends on the nature of function as well. According to the PostgreSQL manual: \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+

[GENERAL] How can I list the function.

2007-02-01 Thread Harvey, Allan AC
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 --++--+-