Re: Cast in PG 8.3 - Mailing list pgsql-sql

From Volkan YAZICI
Subject Re: Cast in PG 8.3
Date
Msg-id 87d4rbm3is.fsf@ttmail.com
Whole thread Raw
In response to Cast in PG 8.3  (Franklin Haut <franklin.haut@gmail.com>)
Responses Multiple postgresql functions in a single transaction  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
List pgsql-sql
Franklin Haut <franklin.haut@gmail.com> writes:
> I Tries  create a cast but the function text doesn't exist more in PG 8.3

sql-createcast.html tells that
 "It is normally not necessary to create casts between user-defined types and the standard string types (text, varchar,
andchar(n)). PostgreSQL will automatically handle a cast to a string type by invoking the other type's output function,
..."

Therefore, this might help you:

test=# SELECT typoutput FROM pg_type WHERE typname = 'int4';typoutput
-----------int4out
(1 row)


Regards.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Negative numbers for PK/ID's?
Next
From: "Jyoti Seth"
Date:
Subject: Multiple postgresql functions in a single transaction