[EMAIL PROTECTED] 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
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 wor
Hi Christopher-- I think we are talking apples and oranges here. Also sorry
for the delay in responding. My son was born on Dec 16th, the day the
message was sent to which I am responding.
Christopher Browne <[EMAIL PROTECTED]> Wrote:
> 1. The businesses that are sufficiently "forward thinking
On Sat, Dec 20, 2003 at 04:14:51PM -0800, Jeff Davis wrote:
> > >
> > > What, exactly, is a partial index? A functional index is an index on
> > > something like ((ColumnX*2)/14)? I think the functional one (is that
> > > also an expression index?) is on the way.
> >
> > A partial index is a in
On 20/12/2003 18:04 Dave Cramer wrote:
I'm actually starting to write one of these for postgres, and apparently
there is another one in the works, from Thomas Hallgren.
There is at least one significant architectural issue here to deal with
Is it more desirable to have a single java vm and communi
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Sat, Dec 20, 2003 at 04:14:51PM -0800, Jeff Davis wrote:
>> Are NULLs even indexed?
> No, but with a partial index you can acheive the same effect.
Actually, btree indexes *do* store nulls. This is not really relevant
to the topic at hand,
[EMAIL PROTECTED] 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
> su
Paul Ganainm schrieb:
SELECT count(*) FROM (SELECT col1, col2 FROM table)
OK, so that's what you call an "inline view" is it?
Yep :-)
What then is a derived table, or is a derived table just a synonym for
inline view?
I'm not sure what the "official" name for this is. I have heard both. So
from
[EMAIL PROTECTED] says...
> > What then is a derived table, or is a derived table just a synonym for
> > inline view?
> I'm not sure what the "official" name for this is. I have heard both. So
> from my point of view a derived table and an inline view are the same.
OK - I'm fine with the
I have a query which does not use column indexes that it should use. I
have discovered some interesting behaviors of Postgres which may
indicate a bug in the database's query planning.
Take a look at the query below. There is a btree index on both
m.account_id and a.account_id. Query (1)
"Steven D.Arnold" <[EMAIL PROTECTED]> writes:
> Query (2) below is the same query, but we reverse the order of the
> tables. It's obviously not quite the same query semantically, even
> though in my case it should always produce the same result.
Since it is in fact not the same query, I'm unc
11 matches
Mail list logo
