Re: dblink: add polymorphic functions.

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: dblink: add polymorphic functions.
Дата
Msg-id 55B9AAF9.4010206@joeconway.com
обсуждение исходный текст
Ответ на Re: dblink: add polymorphic functions.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: dblink: add polymorphic functions.  (Corey Huinker <corey.huinker@gmail.com>)
Re: dblink: add polymorphic functions.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/29/2015 07:58 PM, Tom Lane wrote:
> We can definitely do
> 
> SELECT x::any_single_unreserved_word(some_expression) FROM ...
> 
> because that's actually not something the grammar needs to
> distinguish from type-with-a-typmod; we can deal with the special
> case in LookupTypeName.  It's just a matter of picking a word
> people like.

What about just TYPE then?
   SELECT x::TYPE(some_expression) FROM ...   SELECT CAST (x AS TYPE(some_expression)) FROM ...

- -- 
Joe Conway
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQIcBAEBAgAGBQJVuar5AAoJEDfy90M199hlN8gP/i2IdtOsJ1PasKfUjAegbHf5
HIWLI7lZw2OMb451zrrNJbfTk1xY+OUJX8tRTLku8GyoZ9FrhDnBo0JuZuHMQOo4
ulWPH7JYGQVb89FYANNbubIehfJ0Y5TCr/ihkpmeVR6sTR3OZDSvdVtymF34wfZE
96i2S6QqWHN4V6hNXjTuzaIu4BXFXvZg3N9yNvBRrpnif53jfKPnca6wSeHJgTWv
w8L6mKQbLDW+5azVmuFX/1PyLxMRphsZL6G4+yyASkzQP2VOGDRQrM4Uavoot9Ja
l1Ez4bBoK3ERxfovnSWfwlsqhKmQ41TijoIu/Ex/s1O3dL2LVQ2qBp8cCl8pX9zq
Fnk11ueAvjkVt8/mIQFkGY+noes8vqWGe6yB0FYXjJvFfL4DXgfmthdyyCGJM1l9
JLI034tkflXKEkk5Ty9gOeAaMzqztqmIRYoQKK7O18DOKNH3Fgoa5Vh2Fz/iJI6G
rjQtfcZwv6ukN0qyQ8QB42CvLJVQ5KVwdTSr/93eCipSIuTPJNEoIBSh7H02WN7Q
fqQcKsM9m9ZTkAYP9uQCMEwusiKoPZt41Tdwf5fbhuOHoSim2Tab63eMEoUkRsqu
Bgqql/U5/MRsoAoDp4ALr2LbugnnTVNhrqrP58e45yl+694UEyh9XRpZmWUpX9Lw
k+qPyOJCnLBwOcmS0tv1
=+T37
-----END PGP SIGNATURE-----



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Division by zero in planner.c:grouping_planner()
Следующее
От: Beena Emerson
Дата:
Сообщение: Re: Support for N synchronous standby servers - take 2