"ALLs.org" <i...@alls.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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
