Re: plpgsql question

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: plpgsql question
Дата
Msg-id 200311081614.55035.josh@agliodbs.com
обсуждение исходный текст
Список pgsql-sql
Rich,

> That was my thought - I was fairly sure I fixed it though.....  Do, really
> need to be specific in terms of type in terms of int, or can I put numeric,

INT and numeric are fairly different, and I believe that SRF return types are 
very fussy about data types; I wouldn't be surprised if you got an error for 
using an INT4 in place of an INT8.

> and for varchar(30) I can just put varchar in my type definition.

That I don't think will be a problem; varchar limits are indifferently 
supported anyway.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: plpgsql question
Следующее
От: ow
Дата:
Сообщение: pg 7.4.rc1, Range query performance