From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> |
Cc: | postgres-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Help with select into |
Date: | 2003-03-05 04:07:32 |
Message-ID: | 16468.1046837252@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> writes:
> What I want to do now is save the data as a table, using select into.
> The modified query (as I read the docs) should be:
> SELECT chat_cells.cell_id,
> chat_cells.cell,
> (@@ chat_cells.cell) AS centre,
> int4(id_depth.depth) AS depth,
> chat_cells.substrate
> INTO table1
> FROM chat_cells,
> id_depth
> WHERE (chat_cells.cell_id = id_depth.depth_id);
Looks fine to me.
> When I run this, I get the error message:
> PostgreSQL Error Message:
> ERROR: DECLARE CURSOR must not specify INTO
You had better let us into the secret of what client-side code you're
using. There's no cursor in the stated query, so something is
editorializing on your query...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2003-03-05 04:22:07 | Re: [PATCHES] ALTER SEQUENCE |
Previous Message | Carlos Moreno | 2003-03-05 01:08:34 | Re: |