Re: Duplicate key insert question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: techlist(at)voyager(dot)phys(dot)utk(dot)edu, pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate key insert question
Date: 2003-07-02 03:32:40
Message-ID: 20030702033240.GA8524@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 02, 2003 at 12:08:56 +0900,
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> wrote:
> TAL=# insert into b select 'b', select 'b';
> ERROR: parser: parse error at or near "select" at character 27

You probably want:
insert into b select 'b', 'b';

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2003-07-02 04:34:55 Re: Duplicate key insert question
Previous Message Reuben D. Budiardja 2003-07-02 03:26:46 Re: Duplicate key insert question