Postgres Pro
Downloads
Home   >   mailing lists

Re: Plpsql vs. SQL functions - Mailing list pgsql-hackers

From Alex Pilosov
Subject Re: Plpsql vs. SQL functions
Date
Msg-id Pine.BSO.4.10.10005232224150.21733-100000@spider.pilosoft.com
Whole thread Raw
In response to Plpsql vs. SQL functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Plpsql vs. SQL functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Fwd: Re: SQL3 UNDER
Next
From: Bruce Momjian
Date:
Subject: Re: Plpsql vs. SQL functions