[SQL] Re: Beginner problems with functions

2000-08-22 Thread Andreas Tille
On Mon, 21 Aug 2000, Stephan Szabo wrote: > I haven't thought of an elegant way to do it, although you could > fake some of it with a table of the appropriate structure with a sequence. > It's really ugly, but the pl/sql(tcl/perl/etc...) function gets the > next value of the sequence and inserts

Re: [SQL] Re: Beginner problems with functions

2000-08-21 Thread Stephan Szabo
On Mon, 21 Aug 2000, Andreas Tille wrote: > On Thu, 17 Aug 2000, Stephan Szabo wrote: > > > What you may need to do is declare a variable of type record > > and do SELECT INTO * From ... rather than just > > the SELECT. > Thanks, that worked. > > > Yeah, setof seems fairly wierd. SETOF ba

[SQL] Re: Beginner problems with functions

2000-08-21 Thread Andreas Tille
On Thu, 17 Aug 2000, Stephan Szabo wrote: > What you may need to do is declare a variable of type record > and do SELECT INTO * From ... rather than just > the SELECT. Thanks, that worked. > Yeah, setof seems fairly wierd. SETOF basetype if > you do a SELECT FROM table seems to work though