ORDB and dot-notation query

From: "ALLs(dot)org" <info(at)alls(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: ORDB and dot-notation query
Date: 2009-11-11 04:11:24
Message-ID: 17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have problem with ORDB.

When exec query:

select * from clients WHERE
address.country.tld = 'de'

address and country are custom table and TYPE

I receive error:

*SQL error:
ERROR: schema "adress" does not exist*

Do somebody have some problem and how to fix this?

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2009-11-11 04:15:48 Re: ORDB and dot-notation query
Previous Message rafizeldi 2009-11-10 02:28:02 Re: help-simplify query