Generovanie riadkov v pgsql

[Honza Pazdziora]

On Mon, Jun 07, 2004 at 10:48:44AM +0200, Milan KUNDRAT wrote:
> 
> Pouzival pgsql. Potreboval by som generovat riadky s cislami a neviem si s tym 
> rady. Ked by som ako vstup zadal cislo n, tak by som potreboval vygenerovat 
> riadky s cislami od 1 do n.
> 
> nieco taketo
> 
> nemam_potuchy_aky_prikaz_alebo_funkcia (5)
> -----------------------------------------------------------------
> 1
> 2
> 3
> 4
> 5
> 
> Neviete mi prosim poradit?

Vytvorte funkci vracejici SETOF a pak (v PL/pgSQL) RETURN NEXT.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
		Only self-confident people can be simple.