RAISE NOTICE
RAISE NOTICE
От:
"Ray Madigan" <ray@madigans.org>
Дата:
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
Re: RAISE NOTICE
От:
Greg Williamson <Gregory.Williamson@digitalglobe.com>
Дата:
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.)
Re: RAISE NOTICE
От:
yogesh.arora.daffodil@gmail.com
Дата:
"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
Hello Ray,
You are using the single Quotes in the notice specified by
you...........
You must use
raise notice ''A %'',5;
This is not directly " directly the double quote....it is single quote
two times.......
Regards,
Yogesh Arora