Re: Create Function (SQL) - Mailing list pgsql-sql

From imad
Subject Re: Create Function (SQL)
Date
Msg-id 1f30b80c0611050359l5208a40fo5276f7df3cf65371@mail.gmail.com
Whole thread Raw
In response to Create Function (SQL)  (Mark Simon <mark@manngo.net>)
List pgsql-sql
You can return a record:

create function thing(text) returns record as 'select * from whatever
where id=$1' language sql;

Hope this helps.

--Imad
www.EnterpriseDB.com



On 11/5/06, Mark Simon <mark@manngo.net> wrote:
>
>  I am trying to create a simple function using SQL rather than PGSQL. At
> this point, it's just for the exercise.
>
>  Is it possible to create a function similar to the following:
>
>      create function thing(text) as select * from whatever where id=$1;
>
>  Do I need to specify all of the columns from the table (whatever) as out
> parameters, or as a return type, or can I have a generic table returned from
> this?
>
>  Thanks,
>
>  Mark
>
> --
>
>
> Mark Simon
>
> Manngo Net Pty Ltd
>
> Phone/Fax: 1300 726 000
>  mobile: 0411 246 672
>
> email: mark@manngo.net
>  web: http://www.manngo.net
>
> Resume: http://mark.manngo.net


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Create View
Next
From: "Chuck McDevitt"
Date:
Subject: Re: [HACKERS] Case Preservation disregarding case