Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 31E6F9FB41E for ; Fri, 23 Feb 2007 14:20:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 60056-07 for ; Fri, 23 Feb 2007 14:20:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web54308.mail.yahoo.com (web54308.mail.yahoo.com [206.190.49.118]) by postgresql.org (Postfix) with SMTP id 9AAAA9FB505 for ; Fri, 23 Feb 2007 14:20:06 -0400 (AST) Received: (qmail 84002 invoked by uid 60001); 23 Feb 2007 18:20:04 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=R+YwvQLknVTy506bNg8OOrHpIkhRo8iEbkYWnlEwV6VfRneqhw1wGQojlFTgR/hg7YRwlDPzk/+6xQnj773/xlS/Tse2L9+aPTcPQA800bFlQH0tQv5rNHs8IbL7dErLhMgncyFOug94NDtPoRxFRbYEtZsmbgYpFGumsAhNS38=; X-YMail-OSG: Ytzox0wVM1lmXDLWT9nfxf3.QPLcpxMSEgb_tplxGUAXVANFndZu1ZbJ5.Nfc4DKG1Z93kUlh9Ik1gBwE855ZXvMnwvlSzNZTLfglUyAMoaIgHbfdZ0SbIi2OzH_Tx0qJWnRvFv65gx1KMM- Received: from [24.10.123.39] by web54308.mail.yahoo.com via HTTP; Fri, 23 Feb 2007 10:20:04 PST Date: Fri, 23 Feb 2007 10:20:04 -0800 (PST) From: chester c young Subject: Re: simple web search To: Louis-David Mitterrand Cc: sql pgsql In-Reply-To: <20070223180757.GA22649@apartia.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <658860.73789.qm@web54308.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/232 X-Sequence-Number: 27566 > > create view search_v as select > > 'show'::name as tab_nm, > > show_id as tab_pk, > > 'Show Name' as description, > > show_name as search > > from show > > union select > > 'story'::name, > > story_id, > > 'Story Title', > > title > > from story > > union ... > > > What is that ::name cast for? it's not needed here - sorry. name is the data type pg uses for table names &tc. it's frequently a good idea to cast to name when when messing around in the data dictionary. ____________________________________________________________________________________ TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV. http://tv.yahoo.com/