inquiry using create function

Поиск
Список
Период
Сортировка
От fcarlo@ntsp.nec.co.jp
Тема inquiry using create function
Дата
Msg-id 3BD87A60.E9627E72@ntsp.nec.co.jp
обсуждение исходный текст
Список pgsql-hackers
Hello,

This is my first post here.
I've tried to search the archive and i haven't found
an answer to my problem...here it is...

I created a function with the "create function+setof" keywords...

create function employee(int) returns setof employee as 'select * from
employee where $1 = id'
language 'sql';


Instead of returning a tuple, I get this:
?column?
-----------136491256
I tried exchanging "$1" and "id" but the thing did not yet work.  I
replaced the "*" with the actual fields in my table and it still would
not work. 

What could be the problem?  By the way, I use postgreseql 7.1.3

Thanks!

Carlo Florendo


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: timeout for "idle in transaction"
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: storing binary data