Skip site navigation (1) Skip section navigation (2)

domain casting?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: domain casting?
Date: 2007-08-10 17:21:10
Message-ID: 162867790708101021i4b70ecc0r766f79448b8a0a40@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello

I try casting function for domains. I can do it, but it doesn't work.

betal=# create domain mydomain text;
CREATE DOMAIN
betal=#
betal=# create or replace function mydomain_todate(mydomain)
betal-# returns date as $$
betal$#   select to_date($1, 'YYYYMMDD');
betal$# $$ language sql;
CREATE FUNCTION
betal=#
betal=# create cast (mydomain as date)
betal-# with function mydomain_todate(mydomain);
CREATE CAST
betal=#
betal=# select mydomain_todate('20070715777'::mydomain);
 mydomain_todate
-----------------
 2007-07-15
(1 row)

betal=#
betal=# select '20070715777'::mydomain::date;
ERROR:  invalid input syntax for type date: "20070715777"
betal=#

Is possible casting domain?

Regards
Pavel Stehule

betal=# select version();
                                                version
-------------------------------------------------------------------------------------------------------
 PostgreSQL 8.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070502 (Red Hat 4.1.2-12)
(1 row)

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-08-10 17:47:23
Subject: Re: Unexpected VACUUM FULL failure
Previous:From: Simon RiggsDate: 2007-08-10 17:17:33
Subject: Re: Unexpected VACUUM FULL failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group