Re: Timestamp operator error - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Timestamp operator error
Date
Msg-id web-810172@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Timestamp operator error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Timestamp operator error  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timestamp operator error
Next
From: Tom Lane
Date:
Subject: Re: Timestamp operator error