Function returning subset of columns from table (return type)
| От | Myk |
|---|---|
| Тема | Function returning subset of columns from table (return type) |
| Дата | |
| Msg-id | 20080203195700.fabcb01d.myk@waxfrenzy.org обсуждение исходный текст |
| Ответы |
Re: Function returning subset of columns from table (return
type)
|
| Список | pgsql-general |
Hi
I'm pretty new to PostgreSQL, and have encountered a bit of trouble with functions, namely the return type. Version is
8.0.15.
I have the following table:
note (
id int,
added date,
updated date,
text varchar(1000)
)
and want to define a function that just returns the dates and text by id. I initially just did:
create function note_get (id int)
returns setof note
as 'select * from note where id=$1' language sql;
which was fine. Then later I thought I'd try formatting the columns (they're only intended for display):
create function note_get (
id int
)
returns setof record
as '
select
to_char (added, ''Mon D YYYY''),
to_char (updated, ''Mon D YYYY''),
text
from
note
where
id=$1
' language sql;
but this gives me
ERROR: a column definition list is required for functions returning "record"
Further reading led me to:
create function note_get (
id int,
out added varchar(12),
out updated varchar(12),
out text varchar(1000)
)
returns setof record
...
which got me
ERROR: CREATE FUNCTION / OUT parameters are not implemented
at which point I thought it best to go out for a walk :)
How do I create a function that returns a number of columns like this?
Thanks
--
Mike
В списке pgsql-general по дате отправления: