From: | Kollar Lajos <kollarlajos(at)tigris(dot)klte(dot)hu> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Cc: | kollarlajos(at)tigris(dot)klte(dot)hu |
Subject: | insert... |
Date: | 1998-09-15 11:01:21 |
Message-ID: | 009CC429.0452FC5E.101@tigris.klte.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
suppose that I have two table definitions as follows:
CREATE TABLE a (first int4, second varchar(30));
CREATE TABLE b (b_first int4, b_second a, b_third bool);
How can I insert a row into table 'b'?
I tried
INSERT INTO b values (2, (1, 'something'), 't'); and
INSERT INTO b values (2, "(1, 'something')", 't');
but none of them was correct.
Then I read almost all of man pages, but unfortunately I couldn't find
anything. Maybe you can help me.
Thank you,
Lajos Kollar (kollarlajos(at)tigris(dot)klte(dot)hu)
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares | 1998-09-15 11:14:32 | NOTICE: _outNode: don't know how to print type 715 |
Previous Message | Herouth Maoz | 1998-09-14 15:18:27 | Re: [GENERAL] SELECT from other's tables |