Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id ADAF22E005A for ; Thu, 8 May 2008 07:16:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 42034-01-2 for ; Thu, 8 May 2008 07:16:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14]) by developer.postgresql.org (Postfix) with ESMTP id D6E982E002D for ; Thu, 8 May 2008 07:16:09 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id 1FA2238E98D for ; Thu, 8 May 2008 13:16:06 +0300 (EEST) Received: from [192.168.16.191] (unknown [192.168.16.191]) by nSoft.lt (Postfix) with ESMTP id A8F23BF2FE for ; Thu, 8 May 2008 13:58:46 +0000 (GMT) Message-ID: <4822D2E6.2090004@nsoft.lt> Date: Thu, 08 May 2008 13:16:06 +0300 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: [Fwd: performance: view or function?] Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.191 tagged_above=0 required=5 tests=AWL=0.191 X-Spam-Level: X-Archive-Number: 200805/61 X-Sequence-Number: 29145 Hello, I have one question - what is the difference between the view and a function returning a data set? I mean the performance. Which is better to use? If its the same, I would use functions, because I could use other languages not just SQL to get the results I want. Thank you in advance. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050