Re: Problems with PLPGSQL

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Problems with PLPGSQL
Дата
Msg-id 200311061108.09221.dev@archonet.com
обсуждение исходный текст
Ответ на Re: Problems with PLPGSQL  (Alex <alex@meerkatsoft.com>)
Ответы Re: Problems with PLPGSQL
Re: Problems with PLPGSQL
Список pgsql-general
On Thursday 06 November 2003 10:00, Alex wrote:
> Hi Richard,
> as for the timestamp, both ways work fine, but the other problem still
> exists. using a
> ''60 Min'' works just fine, but WHERE job_end + ($1::text || '' Min'' )

You probably want a cast:
 + ($1::text || '' min'')::interval

--
  Richard Huxton
  Archonet Ltd

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