zmena typu polozky

[Honza Pazdziora]

On Wed, Jun 30, 2004 at 09:40:21AM +0200, Ildiko Takacsova wrote:
> Chcem zmenit polozku psc z varchar(5) na varchar(6)
> 
> begin;
> ALTER TABLE tabulka ADD COLUMN psc2 varchar(6);
> UPDATE tabulka SET psc2=CAST(psc AS varchar(6));
> ALTER TABLE tabulka DROM COLUMN psc;
> ALTER TABLE tabulka RENAME COLUMN psc2 TO psc;
> commit;
> 
> Kde mam chybu?

Presne tam, kde Vam server rika, ze ji mate:

ERROR:  syntax error at or near "DROM" at character 21

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
		Only self-confident people can be simple.