RE:

> 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