create table foo ( serial bar primary key, ...
That does NOT work on my PostgreSQL 7.4.3. What DOES work is:
(assuming you have table foo)
ALTER TABLE foo ADD COLUMN id int;// create an 'id' field, integer
CREATE SEQUENCE foo_id_seq; // create an auto-incrementing seq.
ALTER
Eli Kara wrote:
create table foo ( serial bar primary key, ...
That does NOT work on my PostgreSQL 7.4.3. What DOES work is:
(assuming you have table foo)
ALTER TABLE foo ADD COLUMN id int;// create an 'id' field, integer
CREATE SEQUENCE foo_id_seq; // create an
Voguemaster wrote:
PostgresQL seems to have something like this, see:
http://www.sql.org/sql-database/postgresql/manual/arrays.html
(for those who need yet another reason to switch :-) )
Interbase/Firebird (firebird is open source based on interbase) also have arrays.
It's very fast ad very
firebird is developed under Unix, and have Unix,Linux,Windows,SunOS
(Solrais - also a unix) ports that work the same way on all of them.
When I was commenting on the lack of Win32 support I was referring to
PostgreSQL which is in beta for Win32 (running it under CYGWIN is not
nearly close
Eli Kara wrote:
firebird is developed under Unix, and have Unix,Linux,Windows,SunOS
(Solrais - also a unix) ports that work the same way on all of them.
When I was commenting on the lack of Win32 support I was referring to
PostgreSQL which is in beta for Win32 (running it under CYGWIN is not
Omer Zak wrote:
Daniel Feiglin wrote:
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
booint,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not
PostgresQL seems to have something like this, see:
http://www.sql.org/sql-database/postgresql/manual/arrays.html
(for those who need yet another reason to switch :-) )
Yes, PostgreSQL is a fine DB and there is every good reason to switch :-)
It only suffers from two main problems that I can see:
Voguemaster wrote:
Yes, PostgreSQL is a fine DB and there is every good reason to switch :-)
It only suffers from two main problems that I can see:
1. It's annoying to create a table with an auto-incremented field
(i.e: serial int)
For some reason you have to issue 4 commands... go figure their
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
boo int,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really thrilled about
Daniel Feiglin wrote:
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
booint,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really thrilled about
Daniel Feiglin wrote:
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
booint,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really thrilled about
Ido Kanner wrote:
Hi,
I guess no one will like my suggustion, but here it goes:
Use Firebird (http://www.firebirdsql.org), it does support arrays, but to use
them you need to write things like stored-procedures or UDF (an extention).
Hello folks!
I have a problem with SQL for MySQL (and
12 matches
Mail list logo