public inbox for [email protected]  

help / color / mirror / Atom feed

9.7. Table Functions
2+ messages / 2 participants
[nested] [flat]

* 9.7. Table Functions
@ 2003-09-05 20:34  Elisha Allen <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Elisha Allen @ 2003-09-05 20:34 UTC (permalink / raw)
  To: pgsql-docs

Hello,

I hope I am posting this to the approprate list. I am somewhat new to postgres, and have been extensively reading the documentation over the last few days. As a whole, it is very helpful and informative. Great work!

Today I came across the following issue with table functions:

I'm trying to write a table function that returns a recordset. I'm running postgres 7.3.3 on redhat Following postgres Documentation Chapter 9.7,  I used the following commands to test this:

CREATE TABLE foo (fooid int, foosubid int, fooname text);
 
 CREATE FUNCTION getfoo(int) RETURNS setof foo AS '
     SELECT * FROM foo WHERE fooid = $1;
 ' LANGUAGE SQL;
 
 SELECT * FROM getfoo(1) AS t1;


Unfortunately, the command:

 SELECT * FROM getfoo(1) AS t1;

returns a:

server parse error at or near "("

Is there something I'm missing here? As a workaround I tried:

 SELECT getfoo(1) AS t1;

This command ran, but returned a row t1 with a series of numbers in it, rather than a recordset of columns and values as the documentation suggests when it says:

"If the function returns a composite type, the result columns get the same names as the individual attributes of the type."

Thank you very much for your help, and please let me know if I can be of any assistance in trouble shooting this issue/ updating the documentation on this issue.

Elisha

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: 9.7. Table Functions
@ 2003-09-05 23:32  Tom Lane <[email protected]>
  parent: Elisha Allen <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2003-09-05 23:32 UTC (permalink / raw)
  To: Elisha Allen <[email protected]>; +Cc: pgsql-docs

"Elisha Allen" <[email protected]> writes:
> Unfortunately, the command:
>  SELECT * FROM getfoo(1) AS t1;
> returns a:
> server parse error at or near "("

Works fine here.  You sure you are talking to a 7.3 server?  7.2 or
before would reject it just that way.

			regards, tom lane




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-09-05 23:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-05 20:34 9.7. Table Functions Elisha Allen <[email protected]>
2003-09-05 23:32 ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox