2010/1/14 Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx>: > 2010/1/14 Adrian Klaver <adrian.klaver@xxxxxxxxx>: >> On Wednesday 13 January 2010 10:19:57 pm Vincenzo Romano wrote: >> >>> > >>> > Scott, thanks for that I must have read through that section several >>> > times at least with out picking up on it. >>> > >>> > -- >>> > Adrian Klaver >>> > adrian.klaver@xxxxxxxxx >>> >>> Really? >>> >>> That section is not in any page of the v8.4.2 documentation either PDF or >>> HTML. The sentence has been introduced (yesterday?) in 8.5devel, which is >>> far from being "current". >> >> http://www.postgresql.org/docs/8.4/interactive/plpgsql-implementation.html >> 38.10.1. Variable Substitution >> Last paragraph. >> >>> >>> I only hope they won't change the manual to match the feature/bug >>> (warning: new joke) >>> >>> So that was not a joke at all! :-( >> >> >> >> -- >> Adrian Klaver >> adrian.klaver@xxxxxxxxx >> > > Now I'm pretty surfe it's a bug. > > > CREATE OR REPLACE FUNCTION f() > RETURNS VOID > LANGUAGE plpgsql > AS $function$ > DECLARE > cmd TEXT; > BEGIN > EXECUTE ' > SELECT $l0$ALTER TABLE test ALTER COLUMN i SET DEFAULT $1 $l0$ > ' INTO cmd USING 42; > RAISE INFO '%',cmd; > END; > $function$ > > SELECT f(); > INFO: ALTER TABLE test ALTER COLUMN i SET DEFAULT $1 > > The command to be executed is DML (SELECT). The substitution doesn't take place. yes. You cannot call SELECT 'ALTER ...' Regards Pavel Stehule > > -- > Vincenzo Romano > NotOrAnd Information Technologies > cel. +39 339 8083886 | gtalk. vincenzo.romano@xxxxxxxxxxx > fix. +39 0823 454163 | skype. notorand.it > fax. +39 02 700506964 | msn. notorand.it > NON QVIETIS MARIBVS NAVTA PERITVS > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
