RES: [HACKERS] bug? Drop column and SQL functions

2003-10-29 Thread Thiago Fernandes Moesch
does not need to be recreated. That's a bug or a feature? Regards, Thiago Moesch -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nome de Alvaro Herrera Enviada em: terça-feira, 28 de outubro de 2003 15:28 Para: Hackers Assunto: [HACKERS] bug? Drop colum

[HACKERS] bug? Drop column and SQL functions

2003-10-28 Thread Alvaro Herrera
Someone showed me this simple example: regression=# CREATE TABLE test (a TEXT, b TEXT); CREATE TABLE regression=# INSERT INTO test VALUES ('foo', 'bar'); INSERT 17145 1 regression=# CREATE FUNCTION foo() RETURNS SETOF test as 'SELECT * FROM test' LANGUAGE sql; CREATE FUNCTION regression=# SELECT