Request a Demo
Home   >   mailing lists

Create Function (SQL) - Mailing list pgsql-sql

From Mark Simon
Subject Create Function (SQL)
Date
Msg-id 454D82CC.6090503@manngo.net
Whole thread
Responses Re: Create Function (SQL)
List pgsql-sql
Tree view
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
--
#signature { color: #00008B; font-family: sans-serif; font-size: 10pt;}#signature h1 { font-size: 125%; margin: 4px 0px;}#signature p { margin: 4px 0px;}#signature a { color: #005247; text-decoration: none;}

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: Mark Simon
Date:
Subject: Create View
Next
From: Peter Eisentraut
Date:
Subject: Re: Create View