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.
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 |