From: | "FarjadFarid\(ChkNet\)" <farjad(dot)farid(at)checknetworks(dot)com> |
---|---|
To: | "'David G Johnston'" <david(dot)g(dot)johnston(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: List of shorthand casts |
Date: | 2014-12-09 21:37:38 |
Message-ID: | 009c01d013f8$5c35ef00$14a1cd00$@checknetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Many thank.
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of David G Johnston
Sent: 09 December 2014 20:23
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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.
--
View this message in context:
http://postgresql.nabble.com/List-of-shorthand-casts-tp5829791p5829795.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-12-09 21:39:41 | Re: List of shorthand casts |
Previous Message | Bruce Momjian | 2014-12-09 20:38:46 | Re: Updating single/multiple fields of JSON document |