Re: Custom type literal conversion

On Wed, Sep 24, 2014 at 8:40 AM, hubert depesz lubaczewski <depesz(at)gmail(dot)com
> wrote:

> On Wed, Sep 24, 2014 at 2:45 PM, Chris Bandy <bandy(dot)chris(at)gmail(dot)com>
> wrote:
>
>> I would like to create a new type for version strings that sorts
>> numerically. The composite type below was quick to write and does not
>> require superuser privileges. However, it doesn't respond to type casts the
>> way I'd like.
>>
>> Is there a way to implement this type's literal conversion without
>> resorting to a base type?
>>
>
> I think you need to define casts too, but in any way - check if "semver"
> extension (available on pgxn) doesn't solve your problem.
>
>
Casts from what? The following is not sufficient:

=> CREATE CAST (unknown AS myversion) WITH FUNCTION myversion(unknown);
CREATE CAST
=> SELECT '1.0.9+jenkins'::myversion;
ERROR: malformed record literal: "1.0.9+jenkins"

And cast on "record" isn't valid:

=> CREATE CAST (record AS myversion) WITH FUNCTION myversion(unknown);
ERROR: source data type record is a pseudo-type

I know about the semver extension, but I'm interested in a solution that
does not require extension/superuser access.

Thanks
-- Chris