Re: to_char problem

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Wei Wang" <ww220(at)cam(dot)ac(dot)uk>, "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: to_char problem
Date: 2004-02-17 14:52:00
Message-ID: 200402171452.00213.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Ridge 2004-02-17 14:57:03 Re: ps output and postgres
Previous Message Tom Lane 2004-02-17 14:47:36 Re: psql, 7.4, and the \d command