Re: [PATCHES] SQL/XML publishing function experimental patch II

2005-09-29 Thread David Fetter
On Wed, Sep 28, 2005 at 04:30:54PM +0200, Pavel Stehule wrote:
 Hello
 
 base type changed to text, better registration xmlagg function

Interesting.  The SGML docs appear to be machine-generated stubs.
Could you point to a reference for them so they can be filled in?

Cheers,
D
-- 
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[PATCHES] COPY view

2005-09-29 Thread Karel Zak

 Hi,

attached is a patch that implements COPY view TO feature.

Karel

Example:

test=# CREATE VIEW vvv AS SELECT a.id, a.data AS d1, b.data AS d2 FROM
tab a, tab2 b WHERE a.id=b.fk;
CREATE VIEW
test=# COPY vvv TO '/tmp/test';
COPY
test=# \! cat /tmp/test
1   aaa AAA
2   bbb BBB
3   ccc CCC
4   ddd DDD


-- 
Karel Zak [EMAIL PROTECTED]


pgsql-copyview-29092005.patch.gz
Description: GNU Zip compressed data

---(end of broadcast)---
TIP 6: explain analyze is your friend