Thank's It works also in PostgreSQL!
Emilio Platzer
Igor Tandetnik escribió:
> "Emilio Platzer" <[EMAIL PROTECTED]> wrote
> in message
> news:[EMAIL PROTECTED]
>> I try (and not works):
>>
>> CREATE TABLE nodes(
>> id integer primary key,
>> father_id integer,
>> depth integer);
>> INSERT INTO
"Emilio Platzer" <[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> I try (and not works):
>
> CREATE TABLE nodes(
> id integer primary key,
> father_id integer,
> depth integer);
> INSERT INTO nodes (id,father_id,depth) VALUES (9,null,1);
> INSERT INTO nodes (id,father_id,depth) VALU
I try that solution but don't work. The reason is that in the subquery if
a field don't prefix with an alias (or a table name) the parser supouses
that was of de first table [[[--- Sorry about my poor Englis ---]]]
I try (and not works):
CREATE TABLE nodes(
id integer primary key,
father_id i
On Fri, Mar 21, 2008 at 10:41:10AM -0400, Rob Richardson wrote:
> My SQLite library is built from the single translation unit
> sqlite.c/sqlite.h. That file contains the version number 3.3.17.
>
> I do not have valgrind, but circumstantial evidence that this is a
> SQLite problem is strong. When
Hello,
Is it safe to use this algorithm:
open_db
fork()
sql_do() // both parent and child executes sql statements
close_db
I am not familiar with locking mechanism and I am afraid that if
parent and child will use the same DB handlers it can cause of DB
corruptions
--
Alexander Batyrshin a
Hi All,
Sorry if this has been covered before but I really need some help getting
Sqlite to compile into my project.
I develop in 'C' within the Windows version of the Eclipse Environement
producing embedded systems focused on the Motorola ColdFire Processors
specifically the MCF5282
"Emilio Platzer" <[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> I want to UPDATE a field of one table with data of rows of the same
> table.
>
> For example to calculate the depth of a node in a tree
>
> update nodes as s set s.depth=
>(select f.depth+1
> from nodes as f
>
I want to UPDATE a field of one table with data of rows of the same table.
For example to calculate the depth of a node in a tree
update nodes as s set s.depth=
(select f.depth+1
from nodes as f
where f.id=s.father_id)
where s.depth is null;
I could do this in a ugly way:
I set up a Facebook profile with my pictures, videos and events and I want to
add you as a friend so you can see it. First, you need to join Facebook! Once
you join, you can also create your own profile.
Thanks,
Adelle
Here's the link:
http://www.facebook.com/p.php?i=547162450&k=RYC36XTXUXTF5J
9 matches
Mail list logo