Jay Kreibich wrote:
On Oct 8, 2012, at 3:36 PM, Darren Duncan <dar...@darrenduncan.net> wrote:
Of course, if that is done, then in order to have predictable performance we'd also want
to add some other statement one can invoke when they want to reclaim disk space later,
which actuall
than this
just happening "automatically" (though it could also be configured to happen
automatically).
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
choice less
verbose; in practice, one would more likely do it how you did, however. --
Darren Duncan
Petite Abeille wrote:
On Sep 9, 2012, at 6:51 AM, Darren Duncan <dar...@darrenduncan.net> wrote:
You will need to use a subquery to do what you want, because you want to do a
, ChangeDate) in
(select RowID, max(ChangeDate) as ChangeDate from audtbl group by RowID);
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to actually download and play with it? -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or my
own education, I'd like to know if there is an elegant way of achieving this in
a single query.
Thanks
Nige
You say something like this:
select myfield, count(*) as mycnt from mytbl group by myfield
... where myfield is the one containing the duplicates.
-- Dar
m, between SQLite and Calibre -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
but an alternative solution is to use Postgres 8.4+
(9.1 latest), which lets you do window functions directly in SQL. I know thats
a not-SQLite solution, but it may be the least work to accomplish what you want,
as its still terse/declarational SQL, and its also open source
, or cpanm or cpanplus, to also install DBI if you don't have it.
That's one of the reasons you use those CPAN clients, to effortlessly pull in
dependencies too, essentially like package managers.
Also, cpan and cpanplus are bundled with Perl 5.10.1, but cpanm you have to
install separately.
-- Dar
Steven Michalske wrote:
On Tue, Jan 10, 2012 at 3:19 PM, Darren Duncan <dar...@darrenduncan.net> wrote:
Steven Michalske wrote:
I would like to use the :nnn named parameters but have spaces in the
named parameters.
It seems that ":nnn nnn", :"nn nn", or :nn\
Sreekumar TP wrote:
Is it possible to insert multiple rows using a single statement ?
Yes.
INSERT INTO foo (x, y)
VALUES (1,2), (3,4), (5,6),...;
INSERT INTO foo (x,y)
SELECT x, y FROM bar;
That's at least 2 ways.
-- Darren Duncan
___
sqlite
syntax may be wrong):
WITH (SELECT * FROM a) AS sfa,
(SELECT * FROM b) AS sfb :
SELECT * FROM m WHERE
c IN sfa OR
c IN sfb
AND (NOT c IN sfa
OR c IN sfb));
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
oo = 3" is also a trivial case of a semijoin where the table
you are filtering on has exactly 1 row whose field value is 3, and ostensibly
such WHERE clauses should also be optimizable.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-u
those, same as a mailing list would, and people can
reply by email and then their replies end up on the forum as if someone had used
the web to do it.
It is important to have email copies of everything, which I can archive locally.
-- Darren Duncan
erators is essential.
The non-short-circuiting boolean operators would be for all other uses, where
the validity of one argument doesn't depend on the values of any of the other
arguments, and so the compiler can be free to reorder it.
-- Darren Duncan
__
As I said, this is *good*.
Now if there is any reason to be more restrictive, it would be that one can't
reference a field directly in the select list that isn't in the group by unless
we are grouping by a key of the table that the fields in the select list are
from, so we
prevents anyone from using the SQLite source by itself
under the public domain, no matter how anyone gets their copy of SQLite,
whether
linked with readline or not. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
open-ils.org/ which is an open source project
developed by and for libraries, and that has been used in production for a few
years now in many libraries.
You should adapt this or modify it to meet your needs rather than start a new
one, unless you can
urn some extra column that contains an order number, such
as using the RANK() SQL window function would give you.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dagdamor wrote:
> Darren Duncan <dar...@darrenduncan.net> писал(а) в своём письме Mon, 06 Jun
> 2011 05:08:45 +0600:
>> MySQL should not be considered as the default choice of a non-lite SQL
>> DBMS, for projects not currently using it, when you have a choice between
>&g
Darren Duncan wrote:
> MySQL should be avoided like the plague.
I hereby retract my above-quoted statement as I realize that it is too severe a
statement to be making.
Instead I will say the following in its place:
MySQL should not be considered as the default choice of a non-lite SQL D
Mr. Puneet Kishor wrote:
> On Jun 3, 2011, at 6:16 PM, Darren Duncan wrote:
>> a. MySQL silently ignores all CHECK constraints in all engines, so for
>> example you can't even tell it you want a column to only hold values
>> between 1 and 10. Its in the MySQL docs: "
Mr. Puneet Kishor wrote:
> On Jun 3, 2011, at 1:19 PM, Darren Duncan wrote:
>> MySQL should be avoided like the plague.
>
> why?
>
> This is a long standing (un)conventional wisdom to which I too have hewed.
> Now, it so happens, I will be starting work on a project that
MySQL should be avoided like the plague. Use Postgres instead if you have to
switch to a larger SQL DBMS. But hopefully the help you've gotten so far will
extend your mileage with SQLite and you won't have to switch to anything yet.
--
Darren Duncan
Ian Hardingham wrote:
> Guys, the ser
e you using a
regular file-based database or a MEMORY one? -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
're just
saying that you can only have a z record when you have both corresponding x and
y records. I'm sure there are various business rules that this would
effectively model. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
thing,
which
is a string of bits. Maybe you're just wanting more operators so it is easier
to introspect or manipulate them? -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
function you speak of and how does it differ from "sum"?
Also, it's better to call a function "mean" than "avg" if that's what is
intended, since there are other kinds of averages like "median" and "mode".
-- Darren Duncan
_
Patrick Earl wrote:
> On Sat, Mar 26, 2011 at 10:03 PM, Darren Duncan <dar...@darrenduncan.net>
> wrote:
>> You could store your exact precision numbers as a pair of integers
>> representing
>> a numerator/denominator ratio and then have math operators that work on
rs like they were one number. You would then know at the end how to move
the
radix point since that was kept track of along with the number. -- Darren Duncan
> On Sat, Mar 26, 2011 at 8:15 PM, BareFeetWare <list@barefeetware.com>
> wrote:
>> On 27/03/2011, at 12:39 PM, Patrick
e simplest solution plus
most
efficient in both performance and disk usage.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
did,
not that the way you did it is wrong per se, but just an alternate means to the
end.
I refer to http://search.cpan.org/dist/DBI/DBI.pm#Catalog_Methods :
column_info
foreign_key_info
primary_key_info
table_info
statistics_info
... and those
it
would be more on topic.
-- Darren Duncan
Wols Lists wrote:
> On 15/12/10 02:47, Darren Duncan wrote:
>> Wols Lists wrote:
>>> On 15/12/10 00:18, Darren Duncan wrote:
>>> The point I'm making is that a list doesn't contain any ordering *data*
>>> - it's in
Wols Lists wrote:
> On 15/12/10 00:18, Darren Duncan wrote:
> The point I'm making is that a list doesn't contain any ordering *data*
> - it's inherent in the fact of a list. A list is an abstract concept. In
> Pick, I can store a data structure that IS an abstract list. In an rdb
uch,
and so can other DBMSs, including relational ones, as the implementations
provide. (And even then, operating systems are known to lie about whether data
has been physically written to disk when you fsync.)
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s just a SQL-specific limitation. Other DBMS languages can or do make
that
atomic, and Muldis D does.
> To follow up on my basic mathematics comment - in a list of rational
> numbers, what is the ordinal position of the number "1"?
Normally there isn't an answer to this.
> The basic proofs of "what is infinity" rely on the fact that this
> question has no answer ...
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Wols Lists wrote:
> On 13/12/10 22:44, Darren Duncan wrote:
>> I am also very interested in these subjects.
>>
>> I believe that the relational model can accurately model anything in
>> the real world, and that this can be implemented in efficient ways,
>> wit
ind the scenes.
Ordered lists and bags can be logically binary relations with index+value or
value+count attributes. (That is also the canonical way to do it in Muldis D.)
It is perfectly valid to nest tuples and relations inside each other (these
*are* valid 1NF), and so likewise
Darren Duncan wrote:
> Wols Lists wrote:
>> Dunno how well that approach translates into a relational engine,
>> because Pick has several very non-relational quirks (every "row" MUST
>> have a primary key, the dictionary DEscribes, not PREscribes the FILE,
>>
Wols Lists wrote:
> On 12/12/10 00:29, Darren Duncan wrote:
>> Nonsense. An information schema is a *good* thing, and is generally the
>> *best*
>> tool for introspecting a database. It lets you use all the power features
>> you
>> have when querying data,
t lets you use all the power features you
have when querying data, anything a SELECT can do, and you can query the
database structure likewise. This is the way a relational database is supposed
to work. -- Darren Duncan
___
sqlite-users mailing
Roger Binns wrote:
> On 12/07/2010 08:45 PM, Darren Duncan wrote:
>> I am also working with automated scripts, which now have to be updated to
>> use
>> either the new style or old style depending on the user-requested SQLite
>> version. (DBD::SQLite bundles a S
toconf is the same as for 3.7.3; I would expect -autoconf to
be a proper superset.
2. Why does -amalgamation unzip to the folder name
"sqlite-amalgamation-3070400" but -autoconf untars to the folder name
"sqlite-3.7.4"? Why the inconsistent use of version formats?
-- Darren
Cory Nelson wrote:
> On Sun, Oct 10, 2010 at 8:51 PM, Darren Duncan <dar...@darrenduncan.net>
> wrote:
>> I think that it should be possible to configure SQLite to be strictly
>> read-only
>> in every respect, such that if with such configuration SQLite is
abase. This in contrast to the
approach of apply the journal or WAL and then don't change anything further;
the
latter is also important to support but users should have a choice between the
two options. -- Darren Duncan
___
sqlite-users mailing list
sqli
ne, which happened with release 3.5.5 on 2008 Jan
31. This was a completely backwards-compatible change, hence it came in a
0.0.1
version update. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
no longer updateable by the public; posting in the list can
cause an update there by a registered SQLite developer).
Please do not reply to me directly with your responses. Instead send them to
the forums or file with RT as is appropriate.
Thank you. -- Dar
olution may be to change how the DBD::SQLite tests work.
I'll report here once something's worked out.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Roger Binns wrote:
> On 07/21/2010 08:01 PM, Darren Duncan wrote:
>> Simply substituting in 3.7.0 causes a few new test failures for me with the
>> Perl
>> binding, DBD::SQLite, citing "disk I/O error".
>
> I can't speak for the Perl binding, but some of the
.0" and then building and running "make
test". Building the same version pristine, without the "perl util/getsqlite.pl
3.7.0", passes all tests.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://s
omains of the numeric, text, blob, etc types. This is how I see it, and put
in
those terms, SQLite is still strongly typed, but it is just more flexible than
some other DBMSs, those that don't support generic or union types.
-- Darren Duncan
___
sqlite-users m
ss? What if
you
take away the id column and only have the someint? (I don't recall if you said
the UNIQUE only didn't work if the primary key was used.)
Separately, as was reported in another reply, this issue is something you
should
report as a bug to the OpenOffice people, sin
column you want
unique is in its own table and then you can make that a primary key. Not that
I
actually advise this since then you're just gaining a new problem or two in
place of the one you lost, such as ensuring there's not more than one row in
the
other table per ro
ite
depend on that the same one doesn't work for both versions.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Richard Hipp wrote:
> On Thu, Jun 3, 2010 at 11:15 PM, Darren Duncan <dar...@darrenduncan.net>wrote:
>> Richard Hipp wrote:
> Partition means that one part of the database cannot communicate with
> another part. In the usual use of the CAP theorem, this means that the
> d
Richard Hipp wrote:
> On Sat, May 29, 2010 at 5:42 PM, Darren Duncan <dar...@darrenduncan.net>wrote:
>> "3. Transactions that involve changes against multiple ATTACHed
>> databases are atomic for each individual database, but are not atomic across
>> all
Simon Slavin wrote:
> On 2 Jun 2010, at 1:14am, Darren Duncan wrote:
>
>> What are some examples of the proposed SQL replacements that do this?
>
> You might be interested in NoSQL, or in databases which have no schema: every
> piece of information is a property of an objec
programmer never creates any indices at all. It's up
> to the database engine to decide how to do the searches most efficiently, the
> programmer just says how much memory it can use to do so.
What are some examples of the proposed SQL replacements that do this?
-- Darren Duncan
___
n that this couldn't be done without much
complexity.
Thank you in advance.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
so that then the WAL only has the corresponding
subset
from the earliest reader to the latest?
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Congratulations on this milestone.
I also just realized now that you're adding WAL to SQLite; I have more to say
on
this, but that will be in a new thread.
-- Darren Duncan
D. Richard Hipp wrote:
> The first code check-in for SQLite occurred on 2000-05-29 14:26 UTC -
> ten years ago
urther work, in which case you
have more of a say in its direction and priorities. But mainly I want to see it
get used to enrich projects and their users and developers.
This project and ancillary projects are a serious endeavor that I intend to
commercially support over the long term, and others
ically a table's columns aren't supposed to be ordered either, though SQL
makes them so.
And of course, dump the schema and tables in a mutually consistent order.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dennis Cote wrote:
> On 10-03-09 8:47 PM, Darren Duncan wrote:
>> (Incidentally, I *have* registered my trademark. But that is a non-issue
>> here.)
>>
> Darren,
>
> Aren't you required to put the registered trademark symbol, ®, on each
> use of your trade
Dennis Cote wrote:
> On 10-02-23 3:23 PM, Darren Duncan wrote:
>> Elefterios Stamatogiannakis wrote:
>>
>>> Madis is a extensible relational database system built upon the SQLite
>>> database and with extensions written in Python (via APSW SQLite
>>> w
with it. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ownload a fresh copy
> and try again.
There is *still* a build problem, of a different kind.
With the current http://sqlite.org/sqlite-amalgamation-3.6.23.tar.gz, the
sqlite3.c file is 7.3MB and the sqlite3.h file is 3.7MB, and building fails
horribly. Each file is about 3.7MB larger than
rg/sqlite-amalgamation-3.6.23.tar.gz was; it contains SQLite
3.6.22, not 3.6.23. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
reasonable to support,
essentially an expansion of BETWEEN.
2. Generate a list of values, in which case you need an ordinal type, or a
closure to explicitly generate the next list element from a prior one. Such as
how one may generically define a "sequence generator".
FYI, my M
ts: 1..5, 1..^5, 1^..5, 1^..^5,
where a ^ means exclude that endpoint and its absence means include.
This is more flexible than SQL's BETWEEN, which I believe only covers one of
those 4 options.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sq
parts.
In your case, I would put everything, all your tables, in a single SQLite
database file, if you use SQLite, same as you'd use a single database if you
use
PostgreSQL or other options instead.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-
e stricter and stopped doing implicit casting
between disjoint data types, which would be required for [1='1'] to be true.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to whether I have reasonable
grounds to think there may be confusion between the 2 projects that could
affect
trademark matters.
Thank you in advance.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e) and I will let it in. Anyone
on
dbd-sqlite only that is interested in such issues should also join sqlite-users
so they can post to it directly.
-- Darren Duncan
Original Message
Subject: Re: [Fwd: Re: [sqlite] [DBD-SQLite] Re: SQLite bug ticket - build
fails on sun4-sol
to the list so I'm forwarding a compilation of them for
the
latter's benefit.
-- Darren Duncan
1 of 2:
Original Message
Subject: Re: [DBD-SQLite] Re: [sqlite] SQLite bug ticket - build fails on
sun4-solaris-64int 2.10
Date: Sun, 3 Jan 2010 14:55:39 +1100
From: Adam Kennedy
Duncan
Roger Binns wrote [to sqlite-us...@sqlite.org]:
> Darren Duncan wrote:
>> I would like to bring an apparent SQLite bug to the attention of the SQLite
>> core
>> developers as a ticket, where build fails on sun4-solaris-64int 2.10
>
> You'll find this is not a bug
fixes it; if you think it necessary I
can try asking the tester to try with the newer version.
Thank you.
-- Darren Duncan
--
Output from '/usr/ccs/bin/make':
cc -c -I. -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8
Do bind parameters work for you if you replace the view with a subselect?
Does this work for you?
select * from (
select t1.*,
(select count(*) from song_artist t2 where t1.artist_id=t2.artist_id) as CNT
from artists
) where CNT=:PARAM
-- Darren Duncan
Cariotoglou Mike wrote:
>
e do not reply to me directly with your responses. Instead send them to
the forums or file with RT as is appropriate.
Thank you. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
one of the best features of the relational model. That
it gives users a lot of flexibility while implementations have a lot of
flexibility to optimize behind the scenes, while they can be confident this
optimization won't change the results users get. Not so much with SQL.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
se the SQL DBMSs you already have in the most
effective way possible, in regards to getting the behavior you want error free.
And yes, that is very applicable to SQLite specifically.
-- Darren Duncan
Jay A. Kreibich wrote:
> On Sun, Nov 01, 2009 at 01:23:52PM -0800, CityDev scratched on the wall:
constraints would be necessary to use anyway for the general
case of constraints where the constraint isn't just "all values are of this
generic type".
So, request withdrawn.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlit
is what a table is analogous to save for not being ordered), which is for
example a collection of cases. But some people will tell you tables should be
named after what an individual record in it represents; I disagree with them
(it
is like naming an array after what one of its elements is) but it
rker" had it existed, and you have the added "worker_id"
field
in "work_history" for every history row that would refer to the same worker.
Having the same "worker_id" values in both sibling tables tells the RDBMS which
rows in the 2 tables correspond to each other.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
stem where type
constraints are enforced, that column may take any value.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
trongly support each VALUE being identified with
a type, with this being the most important thing, which SQLite does as far as
it
goes with its distinct Null|Int|Num|Text|Blob values. And so a type definition
for the purposes of a column definition is just a set of what val
by a registered SQLite developer).
Please do not reply to me directly with your responses. Instead send them to
the forums or file with RT as is appropriate.
Thank you. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqli
RDBMS.
And no, I'm not talking about stupid things like saying the number 99
represents
the infinitely far future, nor am I talking about 1000-valued-logic (or Codd's
circa 17-valued-logic). Use your imagination; there are many ways to do what I
propose that are both elegant, easy to und
don't have a reason
to be different. This is what I'm doing with my "Muldis D" language, which is
close to being feature-complete. -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
would be superior, with the conception being that null is
treated as a special marker that is not equal to any other value but is equal
to
itself. This is the semantics that SQLite's new "IS" follows I believe. And
then you don't need any "is"/"as" confusion.
--
users table
column
named "may_login" or "is_moderated". -- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
instead of those from TableB
for TableA records that don't match.
Or alter the above query to taste for the semantics you actually want.
-- Darren Duncan
Peter Haworth wrote:
> Looking for a way to implement the following situation
>
> I need to select entries form TableA and TableB.
ost sense. When people specify NATURAL,
then what they expect is INNER semantics in the general case.
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of source rows that have the same values
for
the subset of their columns with the same names; a cartesian product is a
degenerate case where that subset of columns has zero members, and so since the
empty set matches the empty set every row from each source rowsets would match
ting the above 2 queries differently, I would think that an
error. Are you sure that's what's happening?
If you are natural joining a table to itself, or intersecting a table with
itself, or unioning a table with itself, then hopefully the optimizer is smart
enough to replace that operation wit
meant to say:
CREATE TABLE t2 (x INTEGER PRIMARY KEY, y INTEGER NOT NULL, FOREIGN KEY(y)
REFERENCES t1(a) );
SELECT * FROM t1 NATURAL JOIN t2;
... and no, this is also a cartesian product since (a,b)∩(x,y) is the empty set.
-- Darren Duncan
_
be really great if SQLite would help lead the pack and implement a
DIVIDE operator natively, which is just shorthand syntax for SQL it already
supports.
-- Darren Duncan
P Kishor wrote:
> I don't even know how to title this post, and it just might be
> something very obvious. Either
P Kishor wrote [on sqlite-us...@sqlite.org]:
> On Thu, Oct 15, 2009 at 1:39 AM, Darren Duncan <dar...@darrenduncan.net>
> wrote:
>> All,
>>
>> I am pleased to announce that DBD::SQLite (Self Contained RDBMS in a Perl DBI
>> Driver) version 1.26_05 has be
red SQLite developer).
Please do not reply to me directly with your responses. Instead send them to
the forums or file with RT as is appropriate.
Thank you. -- Darren Duncan
P.S. DBD::SQLite has at least 1 known bug, also in version 1.25, with regard
to
full-text search (FTS3); there is an in
ON ZGroupItem.ZPhDevId = ZPhDev.id
WHERE ZGroupItem.groupId = 1;
-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
201 - 300 of 571 matches
Mail list logo