to_char problem - Mailing list pgsql-general

From Wei Wang
Subject to_char problem
Date
Msg-id 01b301c3f4c1$4a558550$726ee880@weiwang
Whole thread Raw
Responses Re: to_char problem  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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?


Wei

pgsql-general by date:

Previous
From: Brandon Craig Rhodes
Date:
Subject: using a .postgresql/root.crt
Next
From: MaRCeLO PeReiRA
Date:
Subject: Dates