On Tuesday 17 February 2004 12:37, Wei Wang wrote:
> In that case, how do I RAISE NOTICE a text variable such as:
> DECLARE tempstring text;
> BEGIN
> RAISE NOTICE tempstring;

RAISE NOTICE ''%'',tempstring;

Don't forget to double-up (or bacslash-escape) your quotes.

-- 
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to