Thread: Need help doing a PostgreSQL vs Firebird feature comparison

Hi,

I was just wondering if anyone could help me out by taking a look to see
if I missed any important features.

http://www.amsoftwaredesign.com/pg_vs_fb

This comparison is going to be for the benefit of Delphi users.  The
Delphi community is heavily biased to Firebird.

Please post any comments or suggestions here:

http://www.amsoftwaredesign.com/smf/index.php?topic=138.0

You don't need to register.

Thanks,

Tony

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) ON 1=1

(where a.ID parameter is passed from the previous set as a next procedure parameter), but Postgres cannot.

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