Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E012F632A47
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 11 Nov 2009 00:27:18 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 86232-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 11 Nov 2009 04:27:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f203.google.com (mail-qy0-f203.google.com
	[209.85.221.203])
	by mail.postgresql.org (Postfix) with ESMTP id 4B87A632613
	for <pgsql-sql@postgresql.org>; Wed, 11 Nov 2009 00:27:08 -0400 (AST)
Received: by qyk41 with SMTP id 41so340893qyk.29
	for <pgsql-sql@postgresql.org>; Tue, 10 Nov 2009 20:27:07 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:sender:received:in-reply-to
	:references:date:x-google-sender-auth:message-id:subject:from:to
	:content-type; bh=4keqYQIXudfDlOY3DD9ZtAFv71ExzcYVxj1GInZzNQY=;
	b=oYxoAiupbvn2L7w8kOd3TM3Jd3eC0wZUDrBcPTxs5wsXnPITRCLs3ETB1hQups5p1c
	gTZdPP89WPuTKD9jhydboirP1XTlWClVX2ETx8AeJFimVyqYxErNJ4SzigcXI7FlG06m
	6niUwAEy6dJaxGbBUJJrC3+x8bd4ufha37nAU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:date
	:x-google-sender-auth:message-id:subject:from:to:content-type;
	b=atMq7cp1tsGJnmP+dYAARqtc//QJVjQvOqshDm/t/QAlCH1TayD3ox423hM68Ktmo7
	dDAa+TEomxuZuybjroJBcV76RTczJl04Z6uBy5fHJ24b8+t/P/UdZYsV5nD4zDsbavBE
	apWg0lqfYP8QTjAWEjRPQKQfmoBHDxpXMIlIk=
MIME-Version: 1.0
Received: by 10.229.119.154 with SMTP id z26mr147557qcq.38.1257913626920;
 Tue,
	10 Nov 2009 20:27:06 -0800 (PST)
In-Reply-To: <396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com>
References: <17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com>
	<396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com>
Date: Wed, 11 Nov 2009 05:27:06 +0100
X-Google-Sender-Auth: e6bcaeda82f137f1
Message-ID: <17189cdf0911102027p74126eb2p575a60a95b1f8f91@mail.gmail.com>
Subject: Re: ORDB and dot-notation query
From: "ALLs.org" <info@alls.org>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=000e0cd5c770e409cf047810d691
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200911/37
X-Sequence-Number: 33388

--000e0cd5c770e409cf047810d691
Content-Type: text/plain; charset=ISO-8859-1

This is tipfeler when writing mail, but in database it is 100% ok like
below:
I'm also using Windows version, can this be reason of problem?

When exec query:

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

adress and country are custom table and TYPE

I receive error:

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

Thanks

On Wed, Nov 11, 2009 at 5:15 AM, Richard Broersma <
richard.broersma@gmail.com> wrote:

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

--000e0cd5c770e409cf047810d691
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

This is tipfeler when writing mail, but in database it is 100% ok like belo=
w:<br>I&#39;m also using Windows version, can this be reason of problem?<br=
><br>When exec query:<br><br>select * from clients WHERE<br>adress.country.=
tld =3D &#39;de&#39;<br>
<br>adress and country are custom table and TYPE <br><br>I receive error:<b=
r><br><i>SQL error:<br>
ERROR: schema &quot;adress&quot; does not exist</i><br><br>Thanks<br><br><d=
iv class=3D"gmail_quote">On Wed, Nov 11, 2009 at 5:15 AM, Richard Broersma =
<span dir=3D"ltr">&lt;<a href=3D"mailto:richard.broersma@gmail.com">richard=
.broersma@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><=
div class=3D"h5">On Tue, Nov 10, 2009 at 8:11 PM, ALLs.org &lt;<a href=3D"m=
ailto:info@alls.org">info@alls.org</a>&gt; wrote:<br>

<br>
&gt; I have problem with ORDB.<br>
&gt;<br>
&gt; When exec query:<br>
&gt;<br>
&gt; select * from clients WHERE<br>
&gt; address.country.tld =3D &#39;de&#39;<br>
&gt;<br>
&gt; address and country are custom table and TYPE<br>
&gt;<br>
&gt; I receive error:<br>
&gt;<br>
&gt; SQL error:<br>
&gt; ERROR: schema &quot;adress&quot; does not exist<br>
&gt;<br>
&gt; Do somebody have some problem and how to fix this?<br>
<br>
</div></div>Are you sure that you didn&#39;t just misspell address?<br>
<font color=3D"#888888"><br>
<br>
--<br>
Regards,<br>
Richard Broersma Jr.<br>
<br>
Visit the Los Angeles PostgreSQL Users Group (LAPUG)<br>
<a href=3D"http://pugs.postgresql.org/lapug" target=3D"_blank">http://pugs.=
postgresql.org/lapug</a><br>
</font></blockquote></div><br>

--000e0cd5c770e409cf047810d691--