Re: [HACKERS] CAST vs ::

2017-07-13 Thread Tom Lane
"David G. Johnston" writes: > On Thursday, July 13, 2017, Tom Lane wrote: >> Maybe we can hack ruleutils to use >> the CAST syntax only in this specific context. > Given the lack of complaints, and ubiquity of ::, this would seem ideal > and

Re: [HACKERS] CAST vs ::

2017-07-13 Thread David G. Johnston
On Thursday, July 13, 2017, Tom Lane wrote: > Maybe we can hack ruleutils to use > the CAST syntax only in this specific context. > Given the lack of complaints, and ubiquity of ::, this would seem ideal and sufficient. While there is something to be said for using standard

[HACKERS] CAST vs ::

2017-07-13 Thread Tom Lane
In most places, you can write CAST(x AS t) and x::t interchangeably. But that doesn't work for function-in-FROM. This is OK: select * from cast(fdc() as complex); but this is not: select * from fdc()::complex; ERROR: syntax error at or near "::" I just realized that this is a problem for