name of a column returned from a table function

Поиск

Список

Период

Сортировка

От	Iain
Тема	name of a column returned from a table function
Дата	19 января 2004 г. 07:35:52
Msg-id	001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb обсуждение
Ответы	Re: name of a column returned from a table function
Список	pgsql-sql

Дерево обсуждения

DB Version 7,4.

I had a look through the docs, but the information on table functions (those returning SETOF something) seems to have gone missing from the 7.4 docs. I found something under 7.3, but it didn't answer my question, which is...

I've written a little table function that simply returns all the dates in a month. No problems so far. Now I want to outer join this list to another table, but I dont know what to call the column returned by the function. All the examples I saw just had "select * from <fnname>".

I want do something like "select <fnsdatecolname>,... from <myfn> join <atable> on (<fnsdatecolname> = <atablesdatecolname>;

Searching the lists, I found something to the effect that this might have problems. Is that still the case?

Thanks

Iain

В списке pgsql-sql по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

name of a column returned from a table function