[Pkg-postgresql-public] Bug#596278: postgresql-8.4: Please support subselects in "using" clause of "alter column" changing type

Christoph Berg myon at debian.org
Wed Jun 19 13:00:20 UTC 2013


Testcase:

create table links (targeturi text, uri text);
create table pages (pageid integer, uri text);
alter table links alter column targeturi type integer using (select pageid from pages where uri = targeturi);

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/



More information about the Pkg-postgresql-public mailing list