Postgres Pro
Downloads
Home   >   mailing lists

Re: Firebird and PostgreSQL at the DB Corral. - Mailing list pgsql-general

From Paul Ganainm
Subject Re: Firebird and PostgreSQL at the DB Corral.
Date
Msg-id MPG.1a4f8b27fcb5ee829896b9@news.gmane.org
Whole thread Raw
In response to Firebird and PostgreSQL at the DB Corral.  (Paul Ganainm <paulsnewsgroups@hotmail.com>)
Responses Re: Firebird and PostgreSQL at the DB Corral.
List pgsql-general
Tree view 
spam_eater@gmx.net says...

> Paul Ganainm schrieb:


> FB does not support inline views/derived tables, e.g.:

> SELECT count(*) FROM (SELECT col1, col2 FROM table)


If you have IB/FB, there is a sample db that comes with it, Employee.
There is a view in that db called phone_list.

I did select count(*) from phone_list and it worked.



Paul...

> Thomas

--

plinehan  x__AT__x  yahoo  x__DOT__x  com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

pgsql-general by date:

Previous
From: "Mike Hao"
Date:
Subject: Please remove me from the list, thanks
Next
From: Thomas Kellerer
Date:
Subject: Re: Firebird and PostgreSQL at the DB Corral.