[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    [SQL] Function return rows?
From:       "Pat M" <pmeloy () removethispart ! home ! com>
Date:       2001-09-29 16:17:28
[Download RAW message or body]

Can I use a function to execute a query and return a row or set of rows? If
so, can you point me to some examples or perhaps give me an example of a
function that would do roughly the same thing as:

select * from mytable where mytable.name ~* 'aname';

I can't seem to find any examples that return rows, just single ints and
bools and stuff.





---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

[prev in list] [next in list] [prev in thread] [next in thread]