Re: [SQL] Object description at Client Window

[Kumar]

Hi ,
 
Jordan, thanks for ur reply. But I am not asking 
that.
 
I want to get all the column names of any table at the 
PgAdmin3 SQL Window. To make it more clear, actually i wanted to send the table 
name as the input parameter for a function and expecting the column names, data 
types, etc as the output.
 
Is there any command or any system table from that I could 
query the column names of a table (other than \d table name at the command 
prompt).
 
Kumar

  - Original Message - 
  From: 
  Jordan S. 
  Jones 
  To: Kumar 
  Cc: [EMAIL PROTECTED] 
  Sent: Friday, October 17, 2003 11:50 
  AM
  Subject: Re: [SQL] Object description at 
  Client Window
  give psql -E a try.. It will display any internal SQL commands 
  that it uses.Jordan S. JonesKumar wrote:
  



Dear Friends,
 
I am working with Postgres 7.3.4 on RH linux 
7.2.
 
I could get into the command prompt to describe a table 
structure.
 
Welcome to psql, the PostgreSQL interactive 
terminal.
 
Type:  \copyright for distribution 
terms   \h for help with SQL 
commands   \? for help on internal 
slash commands   \g or terminate with 
semicolon to execute query   \q to 
quit
 
training=# \d 
emp    
Table "emp" Column 
| 
Type  | 
Modifiers+---+--- no 
| 
integer   
| name   | character varying(20) 
| age    | 
integer   
|
 
training=#
 
But I wanted to know whether this description could be 
availed at the command prompt. I am using PgAdmin3. I have checked the 
systems tables also. pg_tables can tell us only the table and the columns 
inside tables.
 
Any idea to share with me, please. I am looking for 
something like sp_helptext in MS SQL server.
 
Regards
Kumar-- 
I am nothing but a poor boy. Please Donate..
https://www.paypal.com/xclick/business=list%40racistnames.com&no_note=1&tax=0¤cy_code=USD

Re: [SQL] Object description at Client Window

[Richard Huxton]

On Friday 17 October 2003 09:44, Kumar wrote:
> Hi ,
>
> Jordan, thanks for ur reply. But I am not asking that.
>
> I want to get all the column names of any table at the PgAdmin3 SQL Window.
> To make it more clear, actually i wanted to send the table name as the
> input parameter for a function and expecting the column names, data types,
> etc as the output.
>
> Is there any command or any system table from that I could query the column
> names of a table (other than \d table name at the command prompt).

Try what the man said. Start psql with -E and issue \d mytable and it will 
show you the SQL it uses to produce the table's details.

-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [SQL] Object description at Client Window

[Kumar]

I am sorry. Yes it worked.
Thank you very much Mr. Jordan and Mr. Richard.

- Original Message - 
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Kumar" <[EMAIL PROTECTED]>; "Jordan S. Jones" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 2:54 PM
Subject: Re: [SQL] Object description at Client Window


> On Friday 17 October 2003 09:44, Kumar wrote:
> > Hi ,
> >
> > Jordan, thanks for ur reply. But I am not asking that.
> >
> > I want to get all the column names of any table at the PgAdmin3 SQL
Window.
> > To make it more clear, actually i wanted to send the table name as the
> > input parameter for a function and expecting the column names, data
types,
> > etc as the output.
> >
> > Is there any command or any system table from that I could query the
column
> > names of a table (other than \d table name at the command prompt).
>
> Try what the man said. Start psql with -E and issue \d mytable and it will
> show you the SQL it uses to produce the table's details.
>
> -- 
>   Richard Huxton
>   Archonet Ltd


---(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 get through to the mailing list cleanly

Re: [SQL] Object description at Client Window

[Kumar]

But I have get into another problem. While I execute the following command I
could get the result as U can see below

etgsuite=# SELECT a.attname,format_type(a.atttypid, a.atttypmod),
a.attnotnull, a.atthasd
ef, a.attnum
FROM pg_class c, pg_attribute a
WHERE c.relname = 'companies'
AND a.attnum > 0 AND a.attrelid = c.oid
ORDER BY a.attnum;
  attname   | format_type | attnotnull | atthasdef |
attnum
+-++---+

 company_id | bigint  | t  | t |
1
 name   | character varying(100)  | f  | f |
2
 website| character varying(50)   | f  | f |
3
 address1   | character varying(100)  | f  | f |
4
 address2   | character varying(100)  | f  | f |
5
 city   | character varying(50)   | f  | f |
6
 state  | character varying(50)   | t  | f |
7
 postal_code| character varying(30)   | t  | f |
8
 country| character varying(50)   | t  | f |
9
 account_manager_id | bigint  | t  | f |
10
 primary_contact_id | bigint  | t  | f |
11
 company_type_id| bigint  | t  | f |
12
 status_flag| bigint  | f  | f |
13
 lead_source| bigint  | f  | f |
14
 lead_date  | timestamp without time zone | f  | f |
15
 industry_type  | bigint  | f  | f |
16
 rec_modifier_id| bigint  | t  | f |
17
 rec_created_date   | timestamp without time zone | t  | f |
   18
 rec_modified_date  | timestamp without time zone | f  | f |
19
 rec_deleted_flag   | character(1)| t  | f |
20
(20 rows)

So I tried to create a plpgsql function as follows to return these for all
the table name. So I have created a function like this

CREATE OR REPLACE FUNCTION public.desc_table(varchar)
  RETURNS refcursor AS
'DECLARE

ref REFCURSOR ;
p_tablename ALIAS FOR $1;

BEGIN
OPEN ref FOR
 SELECT a.attname,
  format_type(a.atttypid, a.atttypmod),
  a.attnotnull,
  a.atthasdef,
  a.attnum
 FROM pg_class c, pg_attribute a
 WHERE c.relname = p_tablename
 AND a.attnum > 0
 AND a.attrelid = c.oid
 ORDER BY a.attnum;

RETURN ref;
END;'
  LANGUAGE 'plpgsql' VOLATILE;


While trying to execute this
select desc_table('companies');

I got the following error.
WARNING:  Error occurred while executing PL/pgSQL function desc_table
WARNING:  line 7 at open

ERROR:  Unable to identify an operator '=' for types 'name' and 'character
varying'
 You will have to retype this query using an explicit cast

I have write many functions of the same structure and executed with out
problems. Where I am doing wrong here.

Please shed some light.

Regards
Kumar

- Original Message - 
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Kumar" <[EMAIL PROTECTED]>; "Jordan S. Jones" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 2:54 PM
Subject: Re: [SQL] Object description at Client Window


> On Friday 17 October 2003 09:44, Kumar wrote:
> > Hi ,
> >
> > Jordan, thanks for ur reply. But I am not asking that.
> >
> > I want to get all the column names of any table at the PgAdmin3 SQL
Window.
> > To make it more clear, actually i wanted to send the table name as the
> > input parameter for a function and expecting the column names, data
types,
> > etc as the output.
> >
> > Is there any command or any system table from that I could query the
column
> > names of a table (other than \d table name at the command prompt).
>
> Try what the man said. Start psql with -E and issue \d mytable and it will
> show you the SQL it uses to produce the table's details.
>
> -- 
>   Richard Huxton
>   Archonet Ltd


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [SQL] Object description at Client Window

[achill]

On Fri, 17 Oct 2003, Kumar wrote:

> But I have get into another problem. While I execute the following command I
> could get the result as U can see below
> 
> etgsuite=# SELECT a.attname,format_type(a.atttypid, a.atttypmod),
> a.attnotnull, a.atthasd
> ef, a.attnum
> FROM pg_class c, pg_attribute a
> WHERE c.relname = 'companies'
> AND a.attnum > 0 AND a.attrelid = c.oid
> ORDER BY a.attnum;
>   attname   | format_type | attnotnull | atthasdef |
> attnum
> +-++---+
> 
>  company_id | bigint  | t  | t |
> 1
>  name   | character varying(100)  | f  | f |
> 2
>  website| character varying(50)   | f  | f |
> 3
>  address1   | character varying(100)  | f  | f |
> 4
>  address2   | character varying(100)  | f  | f |
> 5
>  city   | character varying(50)   | f  | f |
> 6
>  state  | character varying(50)   | t  | f |
> 7
>  postal_code| character varying(30)   | t  | f |
> 8
>  country| character varying(50)   | t  | f |
> 9
>  account_manager_id | bigint  | t  | f |
> 10
>  primary_contact_id | bigint  | t  | f |
> 11
>  company_type_id| bigint  | t  | f |
> 12
>  status_flag| bigint  | f  | f |
> 13
>  lead_source| bigint  | f  | f |
> 14
>  lead_date  | timestamp without time zone | f  | f |
> 15
>  industry_type  | bigint  | f  | f |
> 16
>  rec_modifier_id| bigint  | t  | f |
> 17
>  rec_created_date   | timestamp without time zone | t  | f |
>18
>  rec_modified_date  | timestamp without time zone | f  | f |
> 19
>  rec_deleted_flag   | character(1)| t  | f |
> 20
> (20 rows)
> 
> So I tried to create a plpgsql function as follows to return these for all
> the table name. So I have created a function like this
> 
> CREATE OR REPLACE FUNCTION public.desc_table(varchar)
>   RETURNS refcursor AS
> 'DECLARE
> 
> ref REFCURSOR ;
> p_tablename ALIAS FOR $1;
> 
> BEGIN
> OPEN ref FOR
>  SELECT a.attname,
>   format_type(a.atttypid, a.atttypmod),
>   a.attnotnull,
>   a.atthasdef,
>   a.attnum
>  FROM pg_class c, pg_attribute a
>  WHERE c.relname = p_tablename
>  AND a.attnum > 0
>  AND a.attrelid = c.oid
>  ORDER BY a.attnum;
> 
> RETURN ref;
> END;'
>   LANGUAGE 'plpgsql' VOLATILE;
> 
> 
> While trying to execute this
> select desc_table('companies');
> 
> I got the following error.
> WARNING:  Error occurred while executing PL/pgSQL function desc_table
> WARNING:  line 7 at open
> 
> ERROR:  Unable to identify an operator '=' for types 'name' and 'character
> varying'
>  You will have to retype this query using an explicit cast

replace 
WHERE c.relname = p_tablename
with
WHERE c.relname::varchar = p_tablename

> 
> I have write many functions of the same structure and executed with out
> problems. Where I am doing wrong here.
> 
> Please shed some light.
> 
> Regards
> Kumar
> 
> - Original Message - 
> From: "Richard Huxton" <[EMAIL PROTECTED]>
> To: "Kumar" <[EMAIL PROTECTED]>; "Jordan S. Jones" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, October 17, 2003 2:54 PM
> Subject: Re: [SQL] Object description at Client Window
> 
> 
> > On Friday 17 October 2003 09:44, Kumar wrote:
> > > Hi ,
> > >
> > > Jordan, thanks for ur reply. But I am not asking that.
> > >
> > > I want to get all the column names of any table at the PgAdmin3 SQL
> Window.
> > > To make it more clear, actually i wanted to send the table name as the
> > > input parameter for a function and expecting the column names, data
> types,
> > > etc as the output.
> > >
> > > Is there any command or any system table from that I could query the
> column
> > > names of a table (other than \d table name at the command prompt).
> >
> > Try what the man said. Start psql with -E and issue \d mytable and it will
> > show you the SQL it uses to produce the table's details.
> >
> > -- 
> >   Richard Huxton
> >   Archonet Ltd
> 
> 
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
> 
>http://www.postgresql.org/docs/faqs/FAQ.html
> 

-- 
-Achilleus


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Object description at Client Window

[George Weaver]

Kumar,

pg_class.relname is type "name". You are trying to compare it to p_tablename
which is type "varchar".  Try changing your function definition to:

CREATE OR REPLACE FUNCTION public.desc_table(name)


HTH
George

SNIP

> CREATE OR REPLACE FUNCTION public.desc_table(varchar)
>   RETURNS refcursor AS
> 'DECLARE
>
> ref REFCURSOR ;
> p_tablename ALIAS FOR $1;
>
> BEGIN
> OPEN ref FOR
>  SELECT a.attname,
>   format_type(a.atttypid, a.atttypmod),
>   a.attnotnull,
>   a.atthasdef,
>   a.attnum
>  FROM pg_class c, pg_attribute a
>  WHERE c.relname = p_tablename
>  AND a.attnum > 0
>  AND a.attrelid = c.oid
>  ORDER BY a.attnum;
>
> RETURN ref;
> END;'
>   LANGUAGE 'plpgsql' VOLATILE;
>
>
> While trying to execute this
> select desc_table('companies');
>
> I got the following error.
> WARNING:  Error occurred while executing PL/pgSQL function desc_table
> WARNING:  line 7 at open
>
> ERROR:  Unable to identify an operator '=' for types 'name' and 'character
> varying'
>  You will have to retype this query using an explicit cast
>

SNIP


---(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 get through to the mailing list cleanly

Re: [SQL] [postgres] IPv6-Datentyp(en) in PostgreSQL?

[Ewald Geschwinde]

[EMAIL PROTECTED] wrote:

>Hallo, Liste!
>
>Gibt es schon (konkrete) Pläne, analog zum IPv4-Datentyp auch IPv6 als 
>Datentyp in PostgreSQL zu implementieren?
>
>Interessieren würde mich auch, was der Unterschied zwischen den beiden 
>schon bestehenden Datentypen "inet" und "cidr" ist.
>
>Vielen Dank schon im voraus für Eure Antwort.
>
>Gruß
>Struppi
>
>
>
>  
>
ipv6 ist in 7.4 implementiert
ewald geschwinde



Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden 
Sie eine E-Mail an:
[EMAIL PROTECTED]

 

Die Nutzung von Yahoo! Groups ist Bestandteil von 
http://de.docs.yahoo.com/info/utos.html 



---(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 get through to the mailing list cleanly

Re: [SQL] [postgres] IPv6-Datentyp(en) in PostgreSQL?

[Ewald Geschwinde]

http://developer.postgresql.org/
unten der link sgml docs


[EMAIL PROTECTED] wrote:

> Hallo, Ewald,
>
> vielen Dank für Deine Antwort.
>
> Am 17 Oct 2003 um 13:43 hat Ewald Geschwinde geschrieben:
>
>> [EMAIL PROTECTED] wrote:
>>
>> >Hallo, Liste!
>> >
>> >Gibt es schon (konkrete) Pläne, analog zum IPv4-Datentyp auch IPv6 als
>> >Datentyp in PostgreSQL zu implementieren?
>> >
>> >Interessieren würde mich auch, was der Unterschied zwischen den beiden
>> >schon bestehenden Datentypen "inet" und "cidr" ist.
>> >
>> >Vielen Dank schon im voraus für Eure Antwort.
>> >
>> >Gruß
>> >Struppi
>> >
>> >
>> ipv6 ist in 7.4 implementiert
>> ewald geschwinde
>>
> Das ist ja interessant. Dann hab' ich wohl nur noch das Problem, daß 
> der "PostgreSQL User's Guide" bzw. die "PostgreSQL Documentation" mir 
> nicht in der letzten Fassung (für 7.4) vorliegt. Hast Du einen Tip, 
> unter welcher URL man die Fassung(en) für V. 7.4 finden kann?
>
> Vielen Dank schon im voraus für Deine Hilfe.
>
> Gruß
> Struppi
>
>
>
>>
>>
>> Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden
>> Sie eine E-Mail an:
>> [EMAIL PROTECTED]
>>
>> 
>>
>> Die Nutzung von Yahoo! Groups ist Bestandteil von 
> http://de.docs.yahoo.com/info/utos.html
>>
>>
>
>
>
>
> -- 
>
> Stephan Rupp
> - Philologe / Netzwerkspezialist -
> Mirabeauweg 4
> D-72 072  Tübingen
> Tel.: +49 (7071) 84093
> Fax: +49 (7071) 84048
> E-Post:  [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
> *Yahoo! Groups Sponsor*
>
>
> Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden
> Sie eine E-Mail an:
> [EMAIL PROTECTED]
>
>
>
> Die Nutzung von Yahoo! Groups ist Bestandteil der Allgemeinen 
> Geschäftsbedingungen von Yahoo! 
> .




Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden 
Sie eine E-Mail an:
[EMAIL PROTECTED]

 

Die Nutzung von Yahoo! Groups ist Bestandteil von 
http://de.docs.yahoo.com/info/utos.html 



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] new max function

[Rodrigo Gesswein]

Hello!

   I'm looking for a function to calculate the max value from two numbers,
something like max2(a,b) with a,b int

   Does anyone have the trick ?

   Thank you in advance..

Rodrigo!

---(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 get through to the mailing list cleanly

Re: [SQL] [postgres] IPv6-Datentyp(en) in PostgreSQL?

[stephan . rupp]

Hallo, Ewald,


vielen Dank für Deine Antwort.


Am 17 Oct 2003 um 13:43 hat Ewald Geschwinde geschrieben:


> [EMAIL PROTECTED] wrote:
> 
> >Hallo, Liste!
> >
> >Gibt es schon (konkrete) Pläne, analog zum IPv4-Datentyp auch IPv6 
als 
> >Datentyp in PostgreSQL zu implementieren?
> >
> >Interessieren würde mich auch, was der Unterschied zwischen den beiden 
> >schon bestehenden Datentypen "inet" und "cidr" ist.
> >
> >Vielen Dank schon im voraus für Eure Antwort.
> >
> >Gruß
> >Struppi
> >
> >
> ipv6 ist in 7.4 implementiert
> ewald geschwinde
> 
Das ist ja interessant. Dann hab' ich wohl nur noch das Problem, daß der 
"PostgreSQL User's Guide" bzw. die "PostgreSQL Documentation" mir 
nicht in der letzten Fassung (für 7.4) vorliegt. Hast Du einen Tip, unter 
welcher URL man die Fassung(en) für V. 7.4 finden kann?


Vielen Dank schon im voraus für Deine Hilfe.

Gruß
Struppi





> 
> 
> Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden 
> Sie eine E-Mail an:
> [EMAIL PROTECTED]
> 
>  
> 
> Die Nutzung von Yahoo! Groups ist Bestandteil von http://de.docs.yahoo.com/info/utos.html 
> 
> 







-- 


Stephan Rupp
- Philologe / Netzwerkspezialist -
Mirabeauweg 4
D-72 072  Tübingen
Tel.: +49 (7071) 84093
Fax: +49 (7071) 84048
E-Post:  [EMAIL PROTECTED]
[EMAIL PROTECTED]








Yahoo! Groups Sponsor












Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden 
Sie eine E-Mail an:
[EMAIL PROTECTED]





Die Nutzung von Yahoo! Groups ist Bestandteil der Allgemeinen Geschäftsbedingungen von Yahoo!.

[SQL] Add column with specific colid

[Olga Macias]

I have a question
 
How could I add a column in a table but specific 
colid?
 
 
Thanks

Re: [SQL] new max function

[Mike Rylander]

Here's mine:

CREATE FUNCTION max2 (INTEGER,INTEGER) RETURNS INTEGER
  LANGUAGE SQL AS
  'SELECT CASE WHEN $1 > $2 THEN $1 ELSE $2 END';

This returns:

database=# select max2(1,2);
 max2 
--
2
(1 row)

database=# select max2(3,1);
 max2 
--
3
(1 row)


On Friday 17 October 2003 02:13 pm, Rodrigo Gesswein wrote:
> Hello!
>
>I'm looking for a function to calculate the max value from two numbers,
> something like max2(a,b) with a,b int
>
>Does anyone have the trick ?
>
>Thank you in advance..
>
> Rodrigo!
>
> ---(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 get through to the mailing list cleanly

-- 
Mike Rylander


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [SQL] new max function

[Tom Lane]

Mike Rylander <[EMAIL PROTECTED]> writes:
> Here's mine:

> CREATE FUNCTION max2 (INTEGER,INTEGER) RETURNS INTEGER
>   LANGUAGE SQL AS
>   'SELECT CASE WHEN $1 > $2 THEN $1 ELSE $2 END';

BTW, most of the standard datatypes have these already, because they are
the transition functions for the MAX() and MIN() aggregates.  The one
above is int4larger().

regression=# \df *larger
List of functions
  Result data type   |   Schema   |Name|   
Argument data types
-+++--
 money   | pg_catalog | cashlarger | money, money
 date| pg_catalog | date_larger| date, date
 real| pg_catalog | float4larger   | real, real
 double precision| pg_catalog | float8larger   | double precision, 
double precision
 smallint| pg_catalog | int2larger | smallint, smallint
 integer | pg_catalog | int4larger | integer, integer
 bigint  | pg_catalog | int8larger | bigint, bigint
 interval| pg_catalog | interval_larger| interval, interval
 numeric | pg_catalog | numeric_larger | numeric, numeric
 oid | pg_catalog | oidlarger  | oid, oid
 text| pg_catalog | text_larger| text, text
 time without time zone  | pg_catalog | time_larger| time without time 
zone, time without time zone
 timestamp without time zone | pg_catalog | timestamp_larger   | timestamp without 
time zone, timestamp without time zone
 timestamp with time zone| pg_catalog | timestamptz_larger | timestamp with time 
zone, timestamp with time zone
 time with time zone | pg_catalog | timetz_larger  | time with time zone, 
time with time zone
(15 rows)

All of these have matching xxxsmaller() as well.

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] [postgres] IPv6-Datentyp(en) in PostgreSQL?

[stephan . rupp]

Hallo, Liste!

Gibt es schon (konkrete) Pläne, analog zum IPv4-Datentyp auch IPv6 als 
Datentyp in PostgreSQL zu implementieren?

Interessieren würde mich auch, was der Unterschied zwischen den beiden 
schon bestehenden Datentypen "inet" und "cidr" ist.

Vielen Dank schon im voraus für Eure Antwort.

Gruß
Struppi



-- 

Stephan Rupp
- Philologe / Netzwerkspezialist -
Mirabeauweg 4
D-72 072  Tübingen
Tel.: +49 (7071) 84093
Fax: +49 (7071) 84048
E-Post: [EMAIL PROTECTED]
[EMAIL PROTECTED]



Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden 
Sie eine E-Mail an:
[EMAIL PROTECTED]

 

Die Nutzung von Yahoo! Groups ist Bestandteil von 
http://de.docs.yahoo.com/info/utos.html 



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings