<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.8 2000/07/17 03:04:41 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.9 2000/10/23 00:46:07 tgl Exp $

Postgres documentation

-->

<term><replaceable class="parameter">type</replaceable></term>

<listitem>

<para>

The type of an existing aggregate function.

The input datatype of an existing aggregate function,

or <literal>*</literal> if the function accepts any input type.

(Refer to the <citetitle>PostgreSQL User's Guide</citetitle> for

further information about data types.)

<comment>This should become a cross-reference rather than a

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.7 2000/10/05 19:48:18 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.8 2000/10/23 00:46:07 tgl Exp $

Postgres documentation

-->

<date>1999-07-20</date>

</refsynopsisdivinfo>

<synopsis>

DROP OPERATOR <replaceable class="PARAMETER">id</replaceable> ( <replaceable class="PARAMETER">type</replaceable> | NONE[,...] )

DROP OPERATOR <replaceable class="PARAMETER">id</replaceable> ( <replaceable class="PARAMETER">lefttype</replaceable> | NONE, <replaceable class="PARAMETER">righttype</replaceable> | NONE )

</synopsis>

<refsect2 id="R2-SQL-DROPOPERATOR-1">

</listitem>

</varlistentry>

<varlistentry>

<term><replaceable class="parameter">type</replaceable></term>

<term><replaceable class="parameter">lefttype</replaceable></term>

<listitem>

<para>

The type of function parameters.

The type of the operator's left argument; write <literal>NONE</literal> if the

operator has no left argument.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><replaceable class="parameter">righttype</replaceable></term>

<listitem>

<para>

The type of the operator's right argument; write <literal>NONE</literal> if the

operator has no right argument.

</para>

</listitem>

</varlistentry>

</para>

<para>

The left or right type of a left or right unary

operator, respectively,may be specified as <literal>NONE</literal>.

operator, respectively,must be specified as <literal>NONE</literal>.

</para>

<refsect2 id="R2-SQL-DROPOPERATOR-3">

</programlisting>

</para>

<para>

Remove left unary negation operator (<literal>b !</literal>) for booleans:

Remove left unary negation operator (<literal>! b</literal>) for booleans:

<programlisting>

DROP OPERATOR ! (none, bool);

</programlisting>

</para>

<para>

Remove right unary factorial operator (<literal>! i</literal>) for

Remove right unary factorial operator (<literal>i !</literal>) for

<literal>int4</literal>:

<programlisting>

DROP OPERATOR ! (int4, none);

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/xaggr.sgml,v 1.8 2000/07/17 03:04:40 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/xaggr.sgml,v 1.9 2000/10/23 00:46:06 tgl Exp $

-->

<chapter id="xaggr">

CREATE AGGREGATE avg (

sfunc = float8_accum,

basetype = float8,

stype =_float8,

stype =float8[],

finalfunc = float8_avg,

initcond = '{0,0}'

);

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.21 2000/09/29 20:21:34 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.22 2000/10/23 00:46:06 tgl Exp $

-->

<chapter id="xfunc">

EMP, and retrieves multiple results:

<programlisting>

CREATE FUNCTION hobbies (EMP) RETURNSSET OF hobbies

CREATE FUNCTION hobbies (EMP) RETURNSSETOF hobbies

AS 'SELECT hobbies.* FROM hobbies

WHERE $1.name = hobbies.person'

LANGUAGE 'sql';