In a database which we are having we have nearly 100 tables, and in 75% of
the tables we have 6 columns ( INT ) as standard columns. What is standard
columns, if you create a table in this database you should have some default
6 columns in there they should maintain
1. who is the owner of th
>
> OK, so your tables all have the same fields (columns), as if you used
> CREATE TABLE new_table ( LIKE some_template_table ) ?
It will contain some other unique columns for each table.
> meaning that they contain NULL values in that field for every record?
what is the value it may contain
Hi all,
maybe it’s a naive question but I was wondering if there is any
difference, from a performance point of view, between a view and a
function performing the same task, something like:
CREATE VIEW foo AS …;
CREATE FUNCTION getfoo(int) RETURNS SETOF foo AS $$
SELECT * FROM foo WH
Giorgio Valoti <[EMAIL PROTECTED]> schrieb:
> Hi all,
> maybe it?s a naive question but I was wondering if there is any
> difference, from a performance point of view, between a view and a
> function performing the same task, something like:
>
> CREATE VIEW foo AS ?;
> CREATE FUNCTION getfoo(
Giorgio Valoti <[EMAIL PROTECTED]> writes:
> maybe its a naive question but I was wondering if there is any
> difference, from a performance point of view, between a view and a
> function performing the same task,
Yes. Usually the view will win.
regards, tom lane
--
Tom Lane <[EMAIL PROTECTED]> schrieb:
> Giorgio Valoti <[EMAIL PROTECTED]> writes:
> > maybe its a naive question but I was wondering if there is any
> > difference, from a performance point of view, between a view and a
> > function performing the same task,
>
> Yes. Usually the view will
