| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "M(dot) van Egmond" <mvanegmond(at)quetalzorg(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Type cast text to int4 |
| Date: | 2007-09-07 12:05:49 |
| Message-ID: | 20070907120549.GD23630@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 07, 2007 at 01:40:57PM +0200, M. van Egmond wrote:
> Could you please give me the correct syntax to create a basetype using
> pl/pgsql functions instead of external functions?
> Or is this impossible?
It's not possible. You need to be able to deal with raw C strings and
internal datatypes, which pl/pgsql can't do.
What you're trying to do has been done before, so you should check the
archives. In general though you should really just fix the source to
produce valid SQL standard output.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2007-09-07 12:07:44 | Re: Column as arrays.. more efficient than columns? |
| Previous Message | Marko Kreen | 2007-09-07 12:02:49 | Re: Connection pooling |