Re: plpgsql-function with timestamp

Поиск
Список
Период
Сортировка
От Richard Kut
Тема Re: plpgsql-function with timestamp
Дата
Msg-id 200602221346.52217.rkut@intelerad.com
обсуждение исходный текст
Ответ на Re: plpgsql-function with timestamp  ("Christian Stalp" <christian.stalp@gmx.de>)
Список pgsql-novice
Hello!

    Does the :: do a data type conversion?

On Wednesday 22 February 2006 13:22, Christian Stalp wrote:
> The problem is solfed:
> I called the function with this arguments:
>
> SELECT neue_auktion ( 1::numeric, 'robot'::text, 'robot'::text, '1999-01-08
> 04:05:06'::timestamp, '1999-01-08 04:05:06'::timestamp, 10::numeric,
> 10::numeric, 1::numeric);
>
> And this works.
>
> Thank you...
>
> Gruss Christian

--
Regards,

Richard Kut
Database Administrator
Research & Development
Intelerad Medical Systems Inc.
460 Ste-Catherine West, Suite 210
Montreal, Quebec, Canada H3B 1A7
Tel:     514.931.6222 x7733
Fax:     514.931.4653
rkut@intelerad.com
www.intelerad.com

This email or any attachments may contain confidential or legally
privileged information intended for the sole use of the addressees. Any
use, redistribution, disclosure, or reproduction of this information,
except as intended, is prohibited. If you received this
email in error, please notify the sender and remove all copies of the
message, including any attachments.

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: id from a field
Следующее
От: "Christian Stalp"
Дата:
Сообщение: Re: plpgsql-function with timestamp