[Pgsql-ayuda] Como definir funcion

Alvaro Herrera Munoz alvherre@dcc.uchile.cl
Thu, 14 Aug 2003 11:54:30 -0400


On Thu, Aug 14, 2003 at 09:42:58AM -0600, Josu? Maldonado wrote:

> Como puedo definir una funcion que retorne los registros que devuelve 
> esta orden
> select distinct  xind || ''. '' || udname from unidad where not xind is 
> null order by 1;

CREATE VIEW blah AS select distinct  xind || ''. '' || udname from unidad where
not xind is null order by 1;

SELECT * FROM blah;

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)