Skip site navigation (1) Skip section navigation (2)

psql: SELECT INTO with FETCH_COUNT enabled

From: Josh Williams <joshwilliams(at)ij(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: psql: SELECT INTO with FETCH_COUNT enabled
Date: 2010-05-25 04:31:25
Message-ID: 1274761885.4261.233.camel@minidragon (view raw or flat)
Thread:
Lists: pgsql-bugs
While tinkering with some psql settings on 9.0beta1...

[local]:5432|postgres=# \set FETCH_COUNT 1
[local]:5432|postgres=# SELECT foo INTO bar FROM baz;
ERROR:  DECLARE CURSOR cannot specify INTO
LINE 2: SELECT foo INTO bar FROM baz;
                        ^
[local]:5432|postgres=#! 

If I'm reading it right its using src/bin/psql/common.c's
is_select_command() to determine if the query is cursor-able, and that
function is just looking to see that the query starts with 'select' (or
'values'.)

I'm not sure catching a non-alias use of INTO will be all that easy here
without adding undue complexity.  So considering no one else has
reported it at least than I've been able to find, +1 for leaving it as
is.  Just thought I'd post it in case anyone has any better ideas for
tackling it.

- Josh



Responses

pgsql-bugs by date

Next:From: Mark KirkwoodDate: 2010-05-25 04:43:46
Subject: xml data type implications of no =
Previous:From: Tom LaneDate: 2010-05-24 17:27:07
Subject: Re: BUG #5470: EXTRACT(epoch from ...) missing last digit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group