UNLISTEN(l)                                           UNLISTEN(l)

NAME
       UNLISTEN - Stop listening for notification

SYNOPSIS
       UNLISTEN { notifyname | * }

   INPUTS
       notifyname
              Name of previously registered notify condition.

       *      All  current  listen registrations for this backend
              are cleared.

   OUTPUTS
       UNLISTEN
              Acknowledgement that statement has executed.

DESCRIPTION
       UNLISTEN is used to remove an  existing  NOTIFY  registra-
       tion.   UNLISTEN  cancels any existing registration of the
       current Postgres session as a listener on the notify  con-
       dition  notifyname.   The  special  condition wildcard "*"
       cancels all listener registrations for  the  current  ses-
       sion.

       notify(l)  contains a more extensive discussion of the use
       of LISTEN and NOTIFY.

   NOTES
       classname needs not to be a valid class name  but  can  be
       any string valid as a name up to 32 characters long.

       The  backend  does  not complain if you UNLISTEN something
       you were not listening for.  Each backend  will  automati-
       cally execute UNLISTEN * when exiting.

       A restriction in some previous releases of Postgres that a
       classname which does not correspond  to  an  actual  table
       must be enclosed in double-quotes is no longer present.

USAGE
       To subscribe to an existing registration:

       postgres=> LISTEN virtual;
       LISTEN
       postgres=> NOTIFY virtual;
       NOTIFY
       ASYNC NOTIFY of 'virtual' from backend pid '12317' received

       Once  UNLISTEN  has been executed, further NOTIFY commands
       will be ignored:

       postgres=> UNLISTEN virtual;
       UNLISTEN
       postgres=> NOTIFY virtual;
       NOTIFY
       -- notice no NOTIFY event is received

COMPATIBILITY
   SQL92
       There is no UNLISTEN in SQL92.

SQL - Language Statements 15 August 1999                        1