Re: Plpsql vs. SQL functions

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Plpsql vs. SQL functions
Date: 2000-05-24 02:25:02
Message-ID: Pine.BSO.4.10.10005232224150.21733-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 23 May 2000, Bruce Momjian wrote:

> Is there a reason to keep SQL functions now that we have PL/PgSQL,
> except for backward compatibility? What do SQL functions do that can
> not be done in PLpgSQL? Are they faster?

SQL function can return a new tuple. To my knowledge, PLpgSQL cannot.
I hope someone can prove me wrong ;)

-alex

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-05-24 02:30:53 Re: Plpsql vs. SQL functions
Previous Message Robert B. Easter 2000-05-24 02:03:19 Fwd: Re: SQL3 UNDER