Re: ORDB and dot-notation query

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: "ALLs(dot)org" <info(at)alls(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ORDB and dot-notation query
Date: 2009-11-11 04:15:48
Message-ID: 396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Nov 10, 2009 at 8:11 PM, ALLs.org <info(at)alls(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ALLs.org 2009-11-11 04:27:06 Re: ORDB and dot-notation query
Previous Message ALLs.org 2009-11-11 04:11:24 ORDB and dot-notation query