Thread: Fw: set returning functions in v7.3

Fw: set returning functions in v7.3

From
Egyud Csaba
Date:
----- Original Message -----
From: "Brandon Craig Rhodes" <brandon@oit.gatech.edu>
To: "Együd Csaba" <csegyud@freemail.hu>
Sent: Thursday, February 13, 2003 11:16 AM
Subject: Re: [GENERAL] set returning functions in v7.3


Együd Csaba <csegyud@freemail.hu> writes:

> I use version 7.3.2. I'm afraid I forgot something because doesn't work
even
> the CREATE TYPE expression. Is there any procedure to do before using
these
> features.
>
> db=# select * from t_groups;
>  id | groupname |  description
> ----+-----------+----------------
>   1 | admin     | Administrators
> (1 row)
>
> db=# select * from getgroups();
> ERROR:  parser: parse error at or near "("
>
> db=# \d t_groups
>                 Table "t_groups"
>    Column    |         Type          | Modifiers
> -------------+-----------------------+-----------
>  id          | integer               | not null
>  groupname   | character varying(32) | not null
>  description | character varying(32) |
> Primary key: t_groups_pkey
>
> db=#
>
> Any suggestions?

I cannot reproduce this error - you might want to copy this response
to the pgsql mailing list (you replied only to me with the above) and
see if anyone else can offer help - I think they would be very
interested in knowing the error message.  I'll let you know if I think
of something.

--
Brandon Craig Rhodes
http://www.rhodesmill.org/brandon
Georgia Tech
brandon@oit.gatech.edu




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.435 / Virus Database: 244 - Release Date: 2002.12.30.