Re: RAISE NOTICE - Mailing list pgsql-admin

From yogesh.arora.daffodil@gmail.com
Subject Re: RAISE NOTICE
Date
Msg-id 1191486974.507643.134310@o80g2000hse.googlegroups.com
Whole thread Raw
In response to RAISE NOTICE  ("Ray Madigan" <ray@madigans.org>)
List pgsql-admin
"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


pgsql-admin by date:

Previous
From: "Yogesh Arora"
Date:
Subject: Problem in Accessing Array Element at Position
Next
From: yogesh
Date:
Subject: Postgres Array Traversing Problem