Re: hot to determine calculated fields (views)

On Sat, Jan 25, 2003 at 11:50:42AM -0500, Tom Lane wrote:
> will trillich <will@serensoft.com> writes:
> > how can i tell whether i'm looking at a computed field (from a
> > view) as opposed to actual data (brought in directly from a
> > table)? something in pg_attribute, i hope... :)
>
> You mean, how to tell which columns of a view are just "select foo from..."
> and which are more complex expressions?
>
> AFAICS, the only way is to parse the view definition rule.  The system
> won't give you any help on this, because it neither knows nor cares...

so there's no difference in the defined relation (table) between
these two--

    create table first (
        i int,
        j int,
        t text,
        x text
    );

and

    create view last as
    select
                         i,
        i * j         as j,
                         t,
        substr(x,i,j) as x
    from first
    ;

? no flags at all, stored anywhere?

pooh.

--
There are 10 kinds of people:
ones that get binary, and ones that don't.

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !