Re: Execute a function?

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: Steve - DND <postgres(at)digitalnothing(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Execute a function?
Date: 2005-03-15 06:16:20
Message-ID: 342055250.20050315081620@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

If you have a function that returns a recordset instead of just a
value then you would have to do a select * from functionname
You can also try reading the documentation on functions. I believe
section 35 discusses the various pl languages.

Sim
__________________________________________________________

> Been a _very_long while, but try:
>
> SELECT my_function(param_1, param_2) As Answer;

Yep, that did it. I'm such a newb with PG, still trying everything the MSSQL
way first. Is that the proper way to do it even if you have a function that
returns void?

Steve

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

http://www.postgresql.org/docs/faq

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-03-15 08:17:54 Re: Execute a function?
Previous Message Steve - DND 2005-03-15 05:55:24 Re: Execute a function?