2011/10/20 Valentine Gogichashvili <val...@gmail.com>: >> >> I suppose you could argue that selecting a value and implicitly throwing >> it away is confusing to novices, but on the other hand I've seen a whole >> lot of novices confused by the need to write PERFORM instead of SELECT. >> I think it wouldn't be an unreasonable thing to just interpret a SELECT >> with no INTO clause as being a PERFORM (ie execute and discard results). >> Then we'd not have to do anything magic for commands starting with WITH. >> >> regards, tom lane >> > > it would be really a good idea to allow SELECT without INTO in plpgsql.
SELECT without INTO is useless in plpgsql - because you have to drop result. regards Pavel Stehule > PERFORM just makes things much more complicated, without actually adding any > really working "protection" from misusing SELECT without INTO. > With best regards, > -- Valentin Gogichashvili -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs