From: chester c young <chestercyoung@yahoo.com>
To: Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: simple web search
Date: Fri, 23 Feb 2007 10:20:04 -0800 (PST)
Message-ID: <658860.73789.qm@web54308.mail.yahoo.com> (raw)
In-Reply-To: <20070223180757.GA22649@apartia.fr>
> > 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/
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: chestercyoung@yahoo.com, vindex+lists-pgsql-sql@apartia.org
Subject: Re: simple web search
In-Reply-To: <658860.73789.qm@web54308.mail.yahoo.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