insert... - Mailing list pgsql-general

From Kollar Lajos
Subject insert...
Date
Msg-id 009CC429.0452FC5E.101@tigris.klte.hu
Whole thread Raw
List 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@tigris.klte.hu)

pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] SELECT from other's tables
Next
From: "Jose' Soares"
Date:
Subject: NOTICE: _outNode: don't know how to print type 715