Re: getting inet out of char?

From: Andrew Sullivan <sullivana(at)bpl(dot)on(dot)ca>
To: user Postgresql ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: getting inet out of char?
Date: 2000-06-07 13:30:05
Message-ID: 20000607093005.A29370@bpl.on.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 07, 2000 at 12:20:23AM -0400, Tom Lane wrote:

> Seems like the cleanest answer would be to teach PHP about inet data
> type (not to mention other extension types).

I'd like to do that, but I don't even know where to begin. I gather that
something like this is still being worked on (although I guess it will get
integrated with PHP4, rather than 3, and I'm not in a hurry to upgrade).
Anyway, it'd probably take more than my meagre skills could do.

> You could create a C-coded function to do the transformation, or you
> could replace the rule with a trigger coded in pltcl or plperl. I
> believe both the pltcl and plperl languages are basically datatype-
> ignorant --- as long as the textual output from one data value looks
> like the format the input routine for another type is expecting,
> it'll work.

Thanks. At least this isn't one of those cases where I overlooked something
really obvious!

A

--
Andrew Sullivan Computer Services
<sullivana(at)bpl(dot)on(dot)ca> Burlington Public Library
+1 905 639 3611 x158 2331 New Street
Burlington, Ontario, Canada L7R 1J4

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trurl McByte 2000-06-07 13:31:30 Dump
Previous Message Ed Loehr 2000-06-07 13:29:13 Re: [SQL] oracle rownum equivalent?