"ALLs.org" <info(at)alls(dot)org> writes:
> select * from clients WHERE
> address.country.tld = 'de'
> address and country are custom table and TYPE
> I receive error:
> ERROR: schema "adress" does not exist*
Yup, because the SQL standard says that a.b.c means column c in table b
in schema a. You need to write
(address.country).tld
to get the parser started in the right direction.
regards, tom lane