(unnamed)

text/plain

Filename: (unnamed)
Type: text/plain
Part: 0
Message: Re: RAISE concatination/variables in plpgsql
Index: doc/src/sgml/plsql.sgml
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/plsql.sgml,v
retrieving revision 2.26
diff -c -r2.26 plsql.sgml
*** doc/src/sgml/plsql.sgml	2001/05/08 00:09:22	2.26
--- doc/src/sgml/plsql.sgml	2001/05/08 00:25:57
***************
*** 1306,1319 ****
      <productname>Postgres</productname> elog mechanism.
  
  <synopsis>
! RAISE <replaceable class="parameter">level</replaceable> '<replaceable class="parameter">string</replaceable>' <optional>, <replaceable class="parameter">variable</replaceable> <optional>...</optional></optional>;
  </synopsis>
  
!     Inside the format, <literal>%</literal> is used as a placeholder for the
!     subsequent comma-separated identifiers. Possible levels are
!     DEBUG (silently suppressed in production running databases), NOTICE 
!     (written into the database log and forwarded to the client application)
!     and EXCEPTION (written into the database log and aborting the transaction).
     </para>
  
     <para>
--- 1306,1320 ----
      <productname>Postgres</productname> elog mechanism.
  
  <synopsis>
! RAISE <replaceable class="parameter">level</replaceable> '<replaceable class="parameter">format</replaceable>' <optional>, <replaceable class="parameter">variable</replaceable> <optional>...</optional></optional>;
  </synopsis>
  
!     Inside the format, <literal>%</literal> is replaced by the next argument's
!     external representation. Double %'s are left unchanged for internal
!     reasons.  Possible levels are DEBUG (silently suppressed in production
!     running databases), NOTICE (written into the database log and forwarded to
!     the client application) and EXCEPTION (written into the database log and
!     aborting the transaction).
     </para>
  
     <para>