7;;
>
> If this:
>
> alter table foobar add column address varchar(50) default 'none';
>
> is the incorrect syntax, why does it not fail or at least give a
> warning?
Sorry, I meant: Try this workaround :)
cu
--
Nabil Sayegh
---(end of b
res/sql-altertable.htm
The correct syntax is:
ALTER TABLE foobar add column address varchar(50);
ALTER TABLE foobar alter column address set default 'none';
cu
--
Nabil Sayegh
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
day for your timezone.
Just add some hours to the result and you're fine.
(In your example substitute 3 with timespan("3 days 4 hours"))
or something like that.
AFAIK this has been fixed in 7.1
--
Nabil Sayegh
GPG-Key available at http://www.sayegh.de
(see http://www.gnupg.org for details)
RUST. You
have to set it
to PASSWORD
cu
--
Nabil Sayegh
times after a fresh connection
ANY further executions of this query lead to wrong results.
Other queries (of similar structure (UNION)) never work right
How can this be ? It's the same query on the same data.
Apparantly the "preis" column is a rounding-error, but "menge"
is of type integer.
Why does it work if I skip "ins_id" ?
Is it related to the BLCKSIZE ?
TIA
P.S.: Is there hope for OUTER JOIN in 7.1 ?
--
Nabil Sayegh
