From: | Chris Bandy <bandy(dot)chris(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Custom type literal conversion |
Date: | 2014-09-24 12:45:27 |
Message-ID: | CAMDg7WxSnTtb0UhqS31HWrfHGKnvNrLX1C7ASTSBjJcR5kb8Yg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Thanks
-- Chris
===
=> CREATE TYPE myversion AS (version integer[], build varchar);
CREATE TYPE
=> CREATE OR REPLACE FUNCTION myversion(text)
-> RETURNS myversion AS $$
$> SELECT
$> string_to_array(split_part($1, '+', 1), '.')::integer[],
$> split_part($1, '+', 2);
$> $$ LANGUAGE SQL IMMUTABLE STRICT;
CREATE FUNCTION
=> SELECT myversion('1.0.9+jenkins');
myversion
---------------------
("{1,0,9}",jenkins)
(1 row)
=> SELECT '1.0.9+jenkins'::myversion;
ERROR: malformed record literal: "1.0.9+jenkins"
LINE 1: SELECT '1.0.9+jenkins'::myversion;
^
DETAIL: Missing left parenthesis.
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2014-09-24 13:40:35 | Re: Custom type literal conversion |
Previous Message | Tom Lane | 2014-09-24 12:15:02 | Re: pg_dump: [archiver] -C and -c are incompatible options |