Re: Views and functions returning sets of records - Mailing list pgsql-performance

From Tom Lane
Subject Re: Views and functions returning sets of records
Date
Msg-id 29705.1206203639@sss.pgh.pa.us
Whole thread Raw
In response to Views and functions returning sets of records  (Giorgio Valoti <giorgio_v@mac.com>)
Responses Re: Views and functions returning sets of records
List pgsql-performance
Giorgio Valoti <giorgio_v@mac.com> writes:
> 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,

Yes.  Usually the view will win.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Views and functions returning sets of records
Next
From: Andreas Kretschmer
Date:
Subject: Re: Views and functions returning sets of records