views/stored procedures

From: Jeff Davis <jdavis(at)wasabimg(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: views/stored procedures
Date: 2000-11-13 06:29:29
Message-ID: 3A0F8A49.58BEB17C@wasabimg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The previous thread regarding stored procedures made me wonder: what is
the difference between a stored procedure and a view? I understand
postgres uses query rewriting for views, is there a performance hit with

that compared to stored procedures? Will postgres be adding stored
procedures?

Thanks,
Jeff Davis

[PS: I tried sending a similar message to the list yesterday evening,
but it never appeared. I apologize if this is a re-post]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michaël Fiey 2000-11-13 08:25:41 Re: PGBUFFERS
Previous Message Don Baccus 2000-11-13 05:46:06 Re: [HACKERS] PHPBuilder article -- Postgres vs MySQL