On 12/09/2014 01:37 PM, FarjadFarid(ChkNet) wrote:
Hi David,
I mean the ones with "::" like ::text or ::uuid etc
Some of Postgresql data types have two words or more like "double precision"
or " timestamp without time zone". It is not clear how these are
implemented if at all.
Try the query below to get most of the casts available:
select castsource::regtype, casttarget::regtype from pg_cast order by
castsource;
For more info and caveats see:
http://www.postgresql.org/docs/9.3/interactive/catalog-pg-cast.html
Many thank.
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of David G Johnston
Sent: 09 December 2014 20:23
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: List of shorthand casts
FarjadFarid(ChkNet) wrote
Is the list of shorthand casts documented somewhere?
If so can you please direct me to it. A working URL would be great.
Do you mean implicit casts - those that do not require an explicit CAST(...)
or "::" in the query?
Can you give an example of one that you know exists?
The catalog is probably the best way to get a definitive list though I do
not know the exact query you would use. The catalog tables are fairly well
documented so you should start there.
David J.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
