Server programming can mean a few different things. Server programming is not just writing server functions. There are many other things you can do in the server which can be considered programming.
For more complex tasks you can define your own types, operators, and casts from one type to another, letting you actually compare apples and oranges.
As shown in the next example, you can define the type,
fruit_qty, for fruit-with-quantity and then teach PostgreSQL to compare apples and oranges, say to make one orange to be worth 1.5 apples and convert apples to oranges:
postgres=# CREATE TYPE FRUIT_QTY as (name text, qty int); postgres=# SELECT '("APPLE", 3)'::FRUIT_QTY; fruit_quantity ---------------- ...