In that case, how do I RAISE NOTICE a text variable such as: DECLARE tempstring text; BEGIN RAISE NOTICE tempstring; END
----- Original Message ----- From: "Richard Huxton" <[EMAIL PROTECTED]> To: "Wei Wang" <[EMAIL PROTECTED]>; "pgsql" <[EMAIL PROTECTED]> Sent: Monday, February 16, 2004 8:24 PM Subject: Re: [GENERAL] to_char problem > On Monday 16 February 2004 19:15, Wei Wang wrote: > > I get compile error for this code: > > > > > > for i in 1..arg_count-1 LOOP > > RAISE NOTICE quote_literal(to_char(i, ''9'')); > > END LOOP; > > > > where arg_count = 3. > > > > I tried RAISE NOTICE to_char(i, ''9''); as well. > > to_char returns text, right? Then what did I do wrong here? > > Syntax is a little peculiar, you need to do something like > > RAISE NOTICE ''hello % world %'',i,j; > > Nothing else will do. > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
