[SQL] How to return a select query

Hello. I would like to know how can I return a select expresion, and stored in a variable, as cursors, but without the need of fetching it, and just to get the hole resultset. For example. I want to get this query: Select * from table1, and stored in a variable that I can return to, like a row

Re: [SQL] How to store a password encripted in a user defined table

Thanks for your anwers. They have been very useful. Thanks again. - Mensaje original De: John DeSoi <[EMAIL PROTECTED]> Para: Eugenio Flores <[EMAIL PROTECTED]> CC: Andrej Ricnik-Bay <[EMAIL PROTECTED]>; PostgreSQL Enviado: jueves, 1 de marzo, 2007 5:25:28 Asunto

Re: [SQL] How to store a password encripted in a user defined table

Thanks Andrej. But how can I use such algoritms in postgresql? arey they defined in a function that I can call? Or, do I have to code one of those algorithm to use it in my application? - Mensaje original De: Andrej Ricnik-Bay <[EMAIL PROTECTED]> Para: Eugenio Flores &

[SQL] How to store a password encripted in a user defined table

Hello, I wonder if somebody knows how to store passwords in a column that is part of a user defined table. I've been searching and reading the documentation, but I can't find what I'm looking for. I just get password subjects related to client's connections to the database. Thanks in advance