Re: Help with a very newbie question...
От | Cristian Prieto |
---|---|
Тема | Re: Help with a very newbie question... |
Дата | |
Msg-id | 02bf01c519c6$c812c720$6e00a8c0@gt.ClickDiario.local обсуждение исходный текст |
Ответ на | Re: Help with a very newbie question... (Pavel Stehule <stehule@kix.fsv.cvut.cz>) |
Ответы |
Re: Help with a very newbie question...
|
Список | pgsql-general |
RETURNS SETOF Users gave me: getuser ----------------- (cristian,hola) ----- Original Message ----- From: "Richard Huxton" <dev@archonet.com> To: "Pavel Stehule" <stehule@kix.fsv.cvut.cz> Cc: "Cristian Prieto" <cristian@clickdiario.com>; <pgsql-general@postgresql.org> Sent: Wednesday, February 23, 2005 10:34 AM Subject: Re: [GENERAL] Help with a very newbie question... > Pavel Stehule wrote: >>>If I did the following: >>>SELECT * FROM "Users"; >>>I get: >>> >>>userid | passwd >>>----------+-------- >>> cristian | hola >>> >>>AND I execute: >>>SELECT getuser('cristian', 'hola'); >>> >>>I get: >>> getuser >>>----------------- >>> (cristian,hola) >>> >> >> There are two posibilities >> >> SELECT getuser('cristian','hola'); >> SELECT * FROM getuser('cristian','hola') AS (userid varchar, passwd >> varchar); > > Or, define your function as ... RETURNS SETOF Users > > -- > Richard Huxton > Archonet Ltd >
В списке pgsql-general по дате отправления: