Thread: Create Function (SQL)
<tt>I am trying to create a simple function using SQL rather than PGSQL. At this point, it's just for the exercise.<br /><br/> Is it possible to create a function similar to the following:<br /><br /> create function thing(text) as select* from whatever where id=$1;<br /><br /> 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?<br /><br /> Thanks,<br /><br /> Mark<br/></tt><div class="moz-signature">-- <br /><style>#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;} </style><div id="signature"><h1>Mark Simon</h1><p>Manngo Net Pty Ltd<p>Phone/Fax: 1300 726 000<br /> mobile: 0411 246 672<p>email:<a href="mailto:mark@comparity.net">mark@manngo.net</a><br /> web: <a href="http://www.manngo.net">http://www.manngo.net</a><p>Resume:<a href="http://mark.manngo.net">http://mark.manngo.net</a></div></div>
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