Re: hot to determine calculated fields (views)

On Sat, Jan 25, 2003 at 11:50:42AM -0500, Tom Lane wrote:
> will trillich <will(at)serensoft(dot)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(at)serensoft(dot)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/ !