Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8F8F86340C2 for ; Wed, 11 Nov 2009 00:11:33 -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 84376-02 for ; Wed, 11 Nov 2009 04:11:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.24]) by mail.postgresql.org (Postfix) with ESMTP id 7F595633FCB for ; Wed, 11 Nov 2009 00:11:25 -0400 (AST) Received: by qw-out-2122.google.com with SMTP id 3so127500qwe.61 for ; Tue, 10 Nov 2009 20:11:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:date :x-google-sender-auth:message-id:subject:from:to:content-type; bh=GPkFiQY7ycxSVFCJyPZ9uX9M6RIH86PBUatgbPXiSOw=; b=CIKhHNC0Tx5dNAO9Y/Y7GE6ZlsGOspegN36aDUnMWPUfkct8iOK96Z1gFofoLZN3QI 3C80SonlGMWlqfoX6YECqjfS45CCzto/SF3kQq2uIGSfwNE1dFObec4+kGRKFkeEkcLS 1us9Elm1vZzeUDtQhtTBZ/EvOZrJO/kitwx50= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=NiXu29Lx+CPrzjb2ym2DOk86iNz63daHBORMa4PLCscNkdQdI+3XoJQ/XYOHphhCop Quqr+qJimSgIzXS5W0JIXV64q4atv4obzbBriLmt91KE9pWGifXDwApReFtuvgadgXrU kpZCKSBIF290Dkgdo5Ca6o5nMFOC3RZ6G3beo= MIME-Version: 1.0 Received: by 10.229.118.6 with SMTP id t6mr145053qcq.39.1257912684626; Tue, 10 Nov 2009 20:11:24 -0800 (PST) Date: Wed, 11 Nov 2009 05:11:24 +0100 X-Google-Sender-Auth: d9a79c9ba232184a Message-ID: <17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com> Subject: ORDB and dot-notation query From: "ALLs.org" To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd5c6cab9c5d70478109e7b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5 tests=BAYES_20=-0.74, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200911/35 X-Sequence-Number: 33386 --000e0cd5c6cab9c5d70478109e7b Content-Type: text/plain; charset=ISO-8859-1 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 --000e0cd5c6cab9c5d70478109e7b Content-Type: text/html; charset=ISO-8859-1 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 --000e0cd5c6cab9c5d70478109e7b--