[HACKERS] INSERT/SELECT with ORDER BY and LIMIT in 7.1?

2001-03-29 Thread Dirk Lutzebaeck
INSERT INTO t1 SELECT a FROM t2 ORDER BY a LIMIT 10; Is it possible in 7.1? Dirk ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can

Re: [HACKERS] Must a C state transition function use palloc on the returned value?

2000-11-10 Thread Dirk Lutzebaeck
Tom Lane writes: > Dirk Lutzebaeck <[EMAIL PROTECTED]> writes: > > I'm defining a new aggregate using a C transition function. It is of > > type TEXT, so the C function gets pointers (*text) to the internal-state1 and > > next-data-item parameters. > >

[HACKERS] Must a C state transition function use palloc on the returned value?

2000-11-10 Thread Dirk Lutzebaeck
Hi, I'm defining a new aggregate using a C transition function. It is of type TEXT, so the C function gets pointers (*text) to the internal-state1 and next-data-item parameters. Question is if the returning value of type *text must be palloc'ed or can be just taken from the input parameters. I