Re: ORDB and dot-notation query - Mailing list pgsql-sql

From Richard Broersma
Subject Re: ORDB and dot-notation query
Date
Msg-id 396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com
Whole thread Raw
In response to ORDB and dot-notation query  ("ALLs.org" <info@alls.org>)
Responses Re: ORDB and dot-notation query  ("ALLs.org" <info@alls.org>)
List pgsql-sql
On Tue, Nov 10, 2009 at 8:11 PM, ALLs.org <info@alls.org> wrote:

> 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?

Are you sure that you didn't just misspell address?


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

Previous
From: "ALLs.org"
Date:
Subject: ORDB and dot-notation query
Next
From: "ALLs.org"
Date:
Subject: Re: ORDB and dot-notation query