This example in User's Guide section 7.2 doesn't work anymore at all:
tgl=> select @ text '-4.5' as "abs";abs
-----4.5
(1 row)
What really happens is this:
=> select @ text '-4.5' as "abs";
ERROR: Unable to identify a prefix operator '@' for type 'text' You may need to add parentheses or an explicit
cast
Again, delete or new example?
--
Peter Eisentraut peter_e@gmx.net