> ex. select lastname||' '||firstname||' '||address
It's because the parser has no defined precedence for operators like ||.
Try:
select (((lastname || ' ') || firstname) || ' ') || address;
Yes, I know it's annoying. But there's a problem with defining precedence in
the grammar for operators like this. Sorry.
Taral