Re: [Pgsql-ayuda] Como definir funcion

From: Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>
To: Josu? Maldonado <josue(at)lamundial(dot)hn>
Cc: Pgsql <pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx>
Subject: Re: [Pgsql-ayuda] Como definir funcion
Date: 2003-08-14 15:54:30
Message-ID: 20030814155430.GC6882@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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[(at)]dcc(dot)uchile(dot)cl>)
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera Munoz 2003-08-14 15:57:34 Re: [Pgsql-ayuda] Char vs Varchar
Previous Message Alvaro Herrera Munoz 2003-08-14 15:51:10 Re: [Pgsql-ayuda] ayuda con postgres porfa!!!!