Gaetano Mendola <[EMAIL PROTECTED]> writes:
> I'm playing with complex row type:
> ...
> kalman=# alter table test drop column b;
> ALTER TABLE <--- Here I think the server shall complain about
> ~ ( 7.4 doesn't complain neither )
Actually, on looking back at
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
> | It shouldn't work --- the ALTER TABLE code should reject it. Looks like
> | there are a few holes to be plugged here ...
> The SQL standard forbid it ? I was believing that was a pretty cool feature!
> :-)
I don't think we can sup
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Greg Stark <[EMAIL PROTECTED]> writes:
|
|>Gaetano Mendola <[EMAIL PROTECTED]> writes:
|>
|>>kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
|>>INSERT 33639 1
|>>kalman=# select * from test;
|>>~ a |
Greg Stark <[EMAIL PROTECTED]> writes:
> Gaetano Mendola <[EMAIL PROTECTED]> writes:
>> kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
>> INSERT 33639 1
>> kalman=# select * from test;
>> ~ a | b
>> ---+
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
> INSERT 33639 1
> kalman=# select * from test;
> ~ a | b
> ---+
> ~ 1 | (2,"(3,""(4,(5,(6,)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> writes:
|
|>kalman=# create table test ( a integer, b integer );
|>CREATE TABLE
|>kalman=# create table test1 ( c integer , d test );
|>CREATE TABLE
|
|
|>kalman=# alter table test drop column b;
|>A
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> kalman=# create table test ( a integer, b integer );
> CREATE TABLE
> kalman=# create table test1 ( c integer , d test );
> CREATE TABLE
> kalman=# alter table test drop column b;
> ALTER TABLE <--- Here I think the server shall complain abou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm playing with complex row type:
kalman=# create table test ( a integer, b integer );
CREATE TABLE
kalman=# create table test1 ( c integer , d test );
CREATE TABLE
kalman=# insert into test1 values ( 1, (2,3) );
INSERT 17277 1
kalman=# select
