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 по дате отправления: