Thread: Function reference

Function reference

From
brichard@cafod.org.uk (Bruce Richardson)
Date:
Is there a function reference for Postgresql anywhere?  I can't find one
in the standard documentation.

--
Bruce

Re: Function reference

From
Peter Eisentraut
Date:
Bruce Richardson writes:

> Is there a function reference for Postgresql anywhere?  I can't find one
> in the standard documentation.

http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Re: Function reference

From
brichard@cafod.org.uk (Bruce Richardson)
Date:
On Sat, Feb 17, 2001 at 07:16:15PM +0100, Peter Eisentraut wrote:
> Bruce Richardson writes:
>
> > Is there a function reference for Postgresql anywhere?  I can't find one
> > in the standard documentation.
>
> http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm

Yes, I've seen that.  But when I type \df in psql it lists a lot more
functions than are described on those pages.  What do oid() or
likejoinsel() do, for instance?

--
Bruce

Re: Function reference

From
Peter Eisentraut
Date:
Bruce Richardson writes:

> On Sat, Feb 17, 2001 at 07:16:15PM +0100, Peter Eisentraut wrote:
> > Bruce Richardson writes:
> >
> > > Is there a function reference for Postgresql anywhere?  I can't find one
> > > in the standard documentation.
> >
> > http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm
>
> Yes, I've seen that.  But when I type \df in psql it lists a lot more
> functions than are described on those pages.  What do oid() or
> likejoinsel() do, for instance?

The \df listing shows a lot of functions that have internal purposes, like
casting functions (oid(), int4(), varchar(), ...), selectivity estimation
(likejoinsel), functions behind operators (int4pl, oideq), transition
functions for aggregates, indexing functions, etc.

All the user-space functions should be documented at that URL.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/