From: Richard Broersma <richard.broersma@gmail.com>
To: ALLs.org <info@alls.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: ORDB and dot-notation query
Date: Tue, 10 Nov 2009 20:15:48 -0800
Message-ID: <396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com> (raw)
In-Reply-To: <17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com>
References: <17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: richard.broersma@gmail.com, info@alls.org
Subject: Re: ORDB and dot-notation query
In-Reply-To: <396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox