Re: [SQL] Function for adding Money type

2003-01-27 Thread Bruce Momjian
Oliver Elphick wrote: > On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote: > > > This year, my team is planning on improving the MONEY type. Of course, we can > > always make it a user defined type if PostgreSQL doesn't want it. We will at > > least put it into contrib. However, if people t

Re: [SQL] Function for adding Money type

2003-01-26 Thread Oliver Elphick
On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote: > This year, my team is planning on improving the MONEY type. Of course, we can > always make it a user defined type if PostgreSQL doesn't want it. We will at > least put it into contrib. However, if people think that it is useful and > wa

Re: [SQL] Function for adding Money type

2003-01-26 Thread Thomas Good
On Sun, 26 Jan 2003, D'Arcy J.M. Cain wrote: > This year, my team is planning on improving the MONEY type. Of course, we can > always make it a user defined type if PostgreSQL doesn't want it. We will at > least put it into contrib. However, if people think that it is useful and > want to leave

Re: [SQL] Function for adding Money type

2003-01-26 Thread D'Arcy J.M. Cain
On Friday 24 January 2003 19:17, Josh Berkus wrote: > The MONEY type is depreciated, and should have been removed from the > Postgres source but was missed as an oversight. Use NUMERIC instead. Note that not all of us agree. I had to change all of our fields from MONEY to NUMERIC recently beca

Re: [SQL] Function for adding Money type

2003-01-24 Thread David Durst
> David, > >> Are there functions for adding and subtracting this type from itself? >> Or is there a simple way to do it? > > The MONEY type is depreciated, and should have been removed from the > Postgres source but was missed as an oversight. Use NUMERIC instead. > > -- > -Josh Berkus > Aglio

Re: [SQL] Function for adding Money type

2003-01-24 Thread Josh Berkus
David, > Are there functions for adding and subtracting this type from itself? > Or is there a simple way to do it? The MONEY type is depreciated, and should have been removed from the Postgres source but was missed as an oversight. Use NUMERIC instead. -- -Josh Berkus Aglio Database Soluti

[SQL] Function for adding Money type

2003-01-24 Thread David Durst
Are there functions for adding and subtracting this type from itself? Or is there a simple way to do it? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster