Brent Wood <b.wood@niwa.co.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