Re: [SQL] Function that returns a tuple.

2000-10-18 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> How can I write a function in sql or pl- pgsql that returns a set of >> tuples ? > I've had the same question myself for the past month, This is easy enough in terms of what you do in the function, but it's not as useful as you might think because

Re: [SQL] Function that returns a tuple.

2000-10-18 Thread Josh Berkus
Claudio, > How can I write a function in sql or pl- pgsql that returns a set of > tuples ? I've had the same question myself for the past month, which has gone unanswered (hint, hint, Jeff!). Currently I'm using custom functions to build views and then referenceing the views: CREATE FU

Re: [SQL] problem with select where like ']'

2000-10-18 Thread Peter Eisentraut
Joseph Shraibman writes: > The only way I can find is to do a search on something, and select to > search in mailing lists. Then after the search returns click on a link, > and trucate the url to http://www.postgresql.org/mhonarc/ When in doubt, use geocrawler.com. -- Peter Eisentraut [EM

[SQL] Function that returns a tuple.

2000-10-18 Thread Claudio Jose Zanardi Grillo
How can I write a function in sql or pl- pgsql that returns a set of tuples ? Thanks. Claudio