to_char problem

From: "Wei Wang" <ww220(at)cam(dot)ac(dot)uk>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: to_char problem
Date: 2004-02-16 19:15:50
Message-ID: 01b301c3f4c1$4a558550$726ee880@weiwang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simone Crider 2004-02-16 19:26:16 GPG MD5 Checksum for postgres 7.4
Previous Message MaRCeLO PeReiRA 2004-02-16 19:01:58 Dates