Re: RAISE NOTICE

Ray Madigan wrote:
> I am trying to debug a trigger using raise notice. When I add this line
>
> raise notice 'A %', 5;
>
> I get a syntax erreo at or near "A"
>
> I am using version 8.1.2
>
> Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Ray,

You don't say what form of quoting you are using, but maybe you could
try doubling up those quotes ?
raise notice ''A is %'',5;

HTH,

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information and must be protected in
accordance with those provisions. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

(My corporate masters made me say this.)