Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 82E4B63442C for ; Wed, 11 Nov 2009 00:15:57 -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 84878-02 for ; Wed, 11 Nov 2009 04:15:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f198.google.com (mail-yw0-f198.google.com [209.85.211.198]) by mail.postgresql.org (Postfix) with ESMTP id 752AB634346 for ; Wed, 11 Nov 2009 00:15:49 -0400 (AST) Received: by ywh36 with SMTP id 36so642704ywh.15 for ; Tue, 10 Nov 2009 20:15:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=MlNF8NkRig4IQmRuuVNB6OHbvp0sa0+e9TbABkvLE8Y=; b=HAzZnc0pKXGq16hsYkngmkl7aBhClSoG8P/4FROQN9aYXJSRciKT+Hl+YYZKrc1vTR suGmZutKp79cOntcrhNA7qdtrCB+3mqzB0RkPWiLYQLi4MbUMcE9RDZTnycGaG0HA6ge 4j9HxoB4KT7F22UJXwcFsrMroRUopgrITvMkc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=qMBwydJtaZkFHQHLeT0RreC0L1+dWCVi3mf/6cxiL3CddqiyzCKpvaF59bw96SH6Bq vh5Pfp0X1cSOeEtWcSNf2UH5Q0VxMvBvpc8y86Y4QZve8BCYSsJfzcm0NsjY69sFcoIM 6MatJJkQ51xN2DFBfYYFY8dbOf1FTec3ZKLjw= MIME-Version: 1.0 Received: by 10.101.197.40 with SMTP id z40mr1089681anp.68.1257912948327; Tue, 10 Nov 2009 20:15:48 -0800 (PST) In-Reply-To: <17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com> References: <17189cdf0911102011t16863599qa68318b25d2b86dc@mail.gmail.com> Date: Tue, 10 Nov 2009 20:15:48 -0800 Message-ID: <396486430911102015kee20c94jb2dde8c00294e766@mail.gmail.com> Subject: Re: ORDB and dot-notation query From: Richard Broersma To: "ALLs.org" Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200911/36 X-Sequence-Number: 33387 On Tue, Nov 10, 2009 at 8:11 PM, 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