Re: Timestamp operator error

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Timestamp operator error
Дата
Msg-id web-810172@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: Timestamp operator error  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Timestamp operator error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Tom,
> Well, you could delete the date(timestamp) function from pg_proc.
> However, that would prevent getting from timestamp to date even
> with an explicit cast --- so you might want to put it back after
> you've found all the trouble spots.

Hmmmm, no, that won't work, as lots of my functions have explicitcasts.  Thanks anyway.  Hopefully I don't have many
morefunctionswhere I call INTERVAL + TIMESTAMP; I just looked at severaltime-sensitve functions and I'm pretty
consistentwith the other way'round.
 

FMI, though, how difficult is defining an operator if I paid a Cprogrammer to do it?  

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Timestamp operator error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Timestamp operator error