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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to