| From: | Victor Lopez <v(dot)lopez(dot)s(at)ono(dot)com> |
|---|---|
| To: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | retorno opcional ? |
| Date: | 2006-12-06 15:17:21 |
| Message-ID: | 200612061617.21240.v.lopez.s@ono.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
db_data=# CREATE OR REPLACE FUNCTION log.actualiza_sesion(VARCHAR(64)) AS
db_data-# $$
db_data$# DELETE FROM TABLE log.sesiones WHERE sesion = $1;
db_data$# INSERT INTO log.sesiones (sesion) VALUES ('$1');
db_data$# $$
db_data-# LANGUAGE sql;
ERROR: el tipo de retorno de la función debe ser especificado
Yo creía que era opcional !
http://www.postgresql.org/docs/8.1/static/sql-createfunction.html
CREATE [ OR REPLACE ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
[ RETURNS rettype ] <<<<<<<
blablabla
O se me escapa algo.
--
----o---( )---o----
Saludos de Victor Lopez Sabio
v(dot)lopez(dot)s(at)ono(dot)com
--------oooo--------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-12-06 15:26:52 | Re: retorno opcional ? |
| Previous Message | ramirex | 2006-12-06 14:22:02 | Re: Como agregar password a un usuario? |