insert...

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)

Browse pgsql-general by date

  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