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.1a4fc134d8ce2c279896ba@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
spam_eater@gmx.net says...


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

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

> Sure you can do a select from a view, but try the above statement where the
> view definition is "embedded" diretly into the SELECT. This is not
> supported by FB 1.5 - though it will be with 2.0


OK, so that's what you call an "inline view" is it?


What then is a derived table, or is a derived table just a synonym for
inline view?


> I admit that it is not a very important feature, but I have come to like
> it, and sometimes it comes in handy :-)


What's wrong with SELECT COUNT(col1) FROM table?


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: Tom Lane
Date:
Subject: Re: Firebird and PostgreSQL at the DB Corral.
Next
From: Thomas Kellerer
Date:
Subject: Re: Firebird and PostgreSQL at the DB Corral.