retorno opcional ?

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: Raw Message | Whole Thread | 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--------

Responses

Browse pgsql-es-ayuda by date

  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?