| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alex Sokoloff <alex_sokoloff(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: ascii to character conversion in postgres |
| Date: | 2000-09-18 06:18:16 |
| Message-ID: | Pine.LNX.3.96.1000918080326.12920A-100000@ara.zf.jcu.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, 17 Sep 2000, Tom Lane wrote:
> >> Postgres has an 'ascii' function that converts
> >> characters to ascii, values, but it appears to be a
> >> one way street. I can't find a way to convert ascii
> >> values to characters, like 'chr' in Oracle. Anyone
> >> know how to do this?
>
> ichar(). Since that's part of the "oracle_compatibility" file,
> I'd assumed the function name spelling was the same as Oracle's.
> Not so?
Not documented (from oracle_compat.c) in PG documentation:
btrim()
ascii()
ichar()
repeat()
and about ichar() is nothing in Oracle documentation, it's knows chr()
only...
Directly rename it, or add "alias" entry to the pg_proc?
Or ignore? :-)
Karel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB | 2000-09-18 08:07:32 | AW: new relkind for view |
| Previous Message | Tom Lane | 2000-09-18 05:30:03 | Re: Notice and share memory corruption |