Re: Need help doing a PostgreSQL vs Firebird feature comparison - Mailing list pgsql-general

From Tony Caduto
Subject Re: Need help doing a PostgreSQL vs Firebird feature comparison
Date
Msg-id 46CB4233.4050801@amsoftwaredesign.com
Whole thread Raw
In response to Re: Need help doing a PostgreSQL vs Firebird feature comparison  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-general
Dmitry Koterov wrote:
> One difference in SQL syntax is that FireBird could join stored
> procedures like this:
>
> SELECT b.*
> FROM
>   get_ids() a
>   LEFT JOIN get_data(a.ID <http://a.ID>) ON 1=1
>
> (where a.ID <http://a.ID> parameter is passed from the previous set as
> a next procedure parameter), but Postgres cannot.
>
>
>
Can't PostgreSQL do that now though?
Functions with out params are treated like tables as of 8.1.

Later,

Tony

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Converting non-null unique idx to pkey
Next
From: Bill Thoen
Date:
Subject: PG Seg Faults Performing a Query