| From: | Yuri Gordienko <Uriy(dot)Gordienko(at)software(dot)systema(dot)com(dot)ua> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Custom conversion |
| Date: | 2008-02-26 15:50:32 |
| Message-ID: | 47C43548.9070102@software.systema.com.ua |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
How can I make custom conversion? The postgres-documentation can't help
me :(
I'm find this only, but without any examples:
http://www.postgresql.org/docs/8.3/interactive/sql-createconversion.html
CREATE [ DEFAULT ] CONVERSION name
FOR source_encoding TO dest_encoding FROM funcname
The function must have the following signature:
conv_proc(
integer, -- source encoding ID
integer, -- destination encoding ID
cstring, -- source string (null terminated C string)
internal, -- destination (fill with a null terminated C string)
integer -- source string length
) RETURNS void;
How can I make this conv_proc function?
Thank's
--
The best regards
Yuri Gordienko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-02-26 15:50:44 | Re: autovacuum not freeing up unused space on 8.3.0 |
| Previous Message | Simon Riggs | 2008-02-26 15:49:10 | Re: unnesesary sorting after Merge Full Join |