Re: PL/pgSQL 1.2 - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: PL/pgSQL 1.2
Date
Msg-id -8928095228137475260@iso-8859-1msgid
Whole thread Raw
In response to Re: PL/pgSQL 1.2  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers


On 4 sep 2014, at 11:42, Pavel Stehule <pavel.stehule@gmail.com> wrote:
2014-09-04 11:22 GMT+02:00 Joel Jacobson <joel@trustly.com>:
The point was, RETURNS returns 1 while RETURNS SETOF returns 0 .. n.

no RETURNS return "VALUE" (it is not a row) .. and in combination with SELECT - value will be a row. RETURNS SETOF returns rows

I intentionally excluded the data type of what is returned.
1 "VALUE" vs 0...n "VALUES"
Do you still fail to see the point 1 "VALUE" is special in the context of what a function returns?

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PL/pgSQL 1.2
Next
From: Robert Haas
Date:
Subject: Re: PQputCopyEnd doesn't adhere to its API contract