table with no column with some rows inside !!
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all,
is it a paradox or not have table with no column but with rows in in
( I mean, we want it ) ?
Here a way to obtain it.
regression=# select version();
~ version
- ------------------------------------------------------------------------------------------------------------
~ PostgreSQL 8.0devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)
(1 row)
regression=# create table test ();
CREATE TABLE
regression=# alter table test add column a test;
ALTER TABLE
kalman=# insert into test values ( null );
INSERT 4260956 1
regression=# alter table test drop column a;
ALTER TABLE
kalman=# \d test
~ Table "public.test"
~ Column | Type | Modifiers
- --------+------+-----------
kalman=# select count(*) from test1;
~ count
- -------
~ 0
(1 row)
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBEj1D7UpzwH2SGd4RAqodAJ4jCLtE+RcvRljx78d+1Hi4rHJlqwCgvn+L
2a9bO/uLtg8YQcxGedKF/pA=
=XmkI
-----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Hi all,
is it a paradox or not have table with no column but with rows in in
( I mean, we want it ) ?Here a way to obtain it.
It's even easier than that actually;
create table test();
insert into test default values;
insert into test default values;
insert into test default values;
select * from test;
--
(3 rows)
I think it's kind of cool.
Merlin
Import Notes
Resolved by subject fallback