[GENERAL] List of shorthand casts

2014-12-10 Thread FarjadFarid(ChkNet)
Is the list of shorthand casts documented somewhere? If so can you please direct me to it. A working URL would be great. Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
Is the list of shorthand casts documented somewhere? If so can you please direct me to it. A working URL would be great. Many thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread David G Johnston
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

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston Sent: 09 December 2014 20:23 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] List of shorthand casts FarjadFarid(ChkNet) wrote Is the list of shorthand casts documented somewhere? If so can you please

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread Tom Lane
FarjadFarid\(ChkNet\) farjad.fa...@checknetworks.com writes: 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. Any type name

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread Adrian Klaver
...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston Sent: 09 December 2014 20:23 To: pgsql-general@postgresql.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

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
Got it thanks. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane Sent: 09 December 2014 21:40 To: FarjadFarid(ChkNet) Cc: 'David G Johnston'; pgsql-general@postgresql.org Subject: Re: [GENERAL] List

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
Thanks. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: 09 December 2014 21:46 To: FarjadFarid(ChkNet); 'David G Johnston'; pgsql-general@postgresql.org Subject: Re: [GENERAL] List of shorthand casts On 12/09/2014 01:37 PM, FarjadFarid(ChkNet) wrote