Re: Help with select into

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