insert...

Поиск
Список
Период
Сортировка
От Kollar Lajos
Тема insert...
Дата
Msg-id 009CC429.0452FC5E.101@tigris.klte.hu
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Herouth Maoz
Дата:
Сообщение: Re: [GENERAL] SELECT from other's tables
Следующее
От: "Jose' Soares"
Дата:
Сообщение: NOTICE: _outNode: don't know how to print type 715