Fw: set returning functions in v7.3

From: Egyud Csaba <csegyud(at)freemail(dot)hu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Fw: set returning functions in v7.3
Date: 2003-02-14 04:21:23
Message-ID: 000f01c2d3e0$957987a0$800a0a0a@xxx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Együd Csaba <csegyud(at)freemail(dot)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(at)oit(dot)gatech(dot)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.

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2003-02-14 04:23:16 Re: index scan with index cond on first column doesn't recognize sort order of second column
Previous Message Tom Lane 2003-02-14 01:47:32 Re: index scan with index cond on first column doesn't recognize sort order of second column