Skip site navigation (1) Skip section navigation (2)

options for RAISE statement

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: options for RAISE statement
Date: 2008-04-16 11:30:02
Message-ID: (view raw or whole thread)
Lists: pgsql-patches

this patch adds possibility to set additional options (SQLSTATE,
DETAIL, DETAIL_LOG and HINT) for RAISE statement,


I changed keyword from WITH to USING, because I don't would to create
new keyword

RAISE level 'format' [, expression [, ...]] [ USING ( option =
expression [, ... ] ) ];

RAISE EXCEPTION 'Nonexistent ID --> %', user_id
  USING (hint = 'Please, check your user id');

Pavel Stehule

Attachment: raise-options.diff
Description: text/x-patch (10.7 KB)


pgsql-patches by date

Next:From: kenneth d'souzaDate: 2008-04-16 12:00:40
Subject: Re: Reference by output in : \d <table_name>
Previous:From: Simon RiggsDate: 2008-04-16 10:07:09
Subject: Re: Improve shutdown during online backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group