Re: to_char problem - Mailing list pgsql-general

From Richard Huxton
Subject Re: to_char problem
Date
Msg-id 200402171452.00213.dev@archonet.com
Whole thread Raw
In response to Re: to_char problem  ("Wei Wang" <ww220@cam.ac.uk>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql, 7.4, and the \d command
Next
From: Eric Ridge
Date:
Subject: Re: ps output and postgres