On Sun, 2003-12-21 at 18:49, Paul Ganainm wrote:
> [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
[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
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...
> >>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
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,
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
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
[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
> >
> > 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 index on a subset of a table. The case I can think of
> is a list of trans
Paul Ganainm schrieb:
ANSI SQL compliant
X
FB does not support inline views/derived tables, e.g.:
SELECT count(*) FROM (SELECT col1, col2 FROM table)
Thomas
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appr
t;[EMAIL PROTECTED]>
Sent: Thursday, December 18, 2003 1:38 PM
Subject: Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.
> On Tue, 2003-12-16 at 16:04, Paul Ganainm wrote:
> > > Native interfaces for ODBC, JDBC, C, C++, PHP, Perl, TCL, ECPG,
> > > Python, and Ruby
>
On Thursday 18 December 2003 03:53, Paul Ganainm wrote:
> [EMAIL PROTECTED] says...
>
> > Now an index can be used on customer when searching for only unbilled
> > things whereas normally it would also have to search for all historical
> > things as well.
> >
> > So, you get the benefit of a small
[EMAIL PROTECTED] says...
> A partial index is a index on a subset of a table. The case I can think of
> is a list of transactions, some of which are yet to be billed. They have a
> BillID field which is NULL. since this is the recent set it is queried quite
> often, so you can build an index li
> The only reason PG views aren't
> updateable by default is (AIUI) a lack of agreement on how they should
> work for complex view definitions.
Actually I think it's more that no one has felt like tackling it. The
SQL spec only requires views to be updatable when they are "sufficiently
simple", an
[EMAIL PROTECTED] says...
> > Ditto for FB. If you want to extend the code, though, you have to give
> > those changes back to the community - the licence is more GPL than BSD.
> maybe you need to clarify what you think of when you say "extensible".
> postgresql has sql extensions like "cre
Paul Ganainm wrote:
Hi all,
Following up on another thread, here is a comparison between FB and PG
from an FB'ers POV. BTW, FB is the love-child of Open-Source-Interbase.
I would love to have this comparison in a table form and posted on web. Let FB
guys chip in and make it more correct..
The
On 16/12/2003 21:04 Paul Ganainm wrote:
Hi Paul,
---
> Better than row-level locking
X (I assume that what is meant here is MVCC?)
One thing I couldn't find when looking at the FB on-line docs a week or
two ago was anything like support for transact
17 matches
Mail list logo