Thread: this one's simpler
Ok, I think this questions is a little bit easier. I have this piece of code: select (max(date_asked) - min(date_asked))::timespan from questions ; And it produces this output: timespan ------------------------------------ @ 2334 days 13 hours 21 mins 45 secs (1 row) Now, what I'd really like is a way to format that output into months so that I could see the difference between the two dates in terms of months. Pointers?? TIA... eric _______________________ Eric McKeown ericm@palaver.net http://www.palaver.net
On Mon, 24 Aug 1998, Eric McKeown wrote: > Ok, I think this questions is a little bit easier. I have this piece of > code: > > select (max(date_asked) - min(date_asked))::timespan from questions ; > > And it produces this output: > > timespan > ------------------------------------ > @ 2334 days 13 hours 21 mins 45 secs > (1 row) > > Now, what I'd really like is a way to format that output into months so > that I could see the difference between the two dates in terms of months. > Pointers?? Well, since not every month has the same number of days, and not every *year* has the same number of days, I think this would only be possible if you also give same starting date (ie min(date_asked)). I'd try to write a C-function for this I guess. Maarten _____________________________________________________________________________ | TU Delft, The Netherlands, Faculty of Information Technology and Systems | | Department of Electrical Engineering | | Computer Architecture and Digital Technique section | | M.Boekhold@et.tudelft.nl | -----------------------------------------------------------------------------
Hi. I hope this is not a too much trivial question. I'm having problems when compiling a new SPI function. I've been doing it with : gcc -I/usr/src/postgresql-6.3.2/src/include -I/usr/src/postgresql-6.3.2/src/backend -Wall -Wmissing-prototypes -fpic -I/usr/src/postgresql-6.3.2/src/include -c cascade.c -o cascade.o but when I call de .o file from the function attached to the trigger , I get the next message: ERROR: Load of file /SAP/SQL/funcs/spi/cascade.o failed: /SAP/SQL/funcs/spi/cascade.o: ELF file's phentsize not the expected size What can I do ??? _______________________________________ David Martinez Cuevas Direccion General de Estadistica, UNAM - Mexico Tel. 622-60-80 E-mail david@estadistica.unam.mx ----------------------------------------
Aren't you supposed to link SPI functions as shared libraries? Try: gcc -shared -o cascade.so cascade.o Taral > -----Original Message----- > From: owner-pgsql-sql@hub.org [mailto:owner-pgsql-sql@hub.org]On Behalf > Of Jose David Martinez Cuevas > Sent: Tuesday, August 25, 1998 1:07 PM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] Having problems to compile SPI > > > > Hi. > > I hope this is not a too much trivial question. > > I'm having problems when compiling a new SPI function. I've been doing it > with : > > gcc -I/usr/src/postgresql-6.3.2/src/include > -I/usr/src/postgresql-6.3.2/src/backend > -Wall -Wmissing-prototypes > -fpic -I/usr/src/postgresql-6.3.2/src/include > -c cascade.c -o cascade.o > > but when I call de .o file from the function attached to the trigger , I > get the next message: > > > ERROR: Load of file /SAP/SQL/funcs/spi/cascade.o failed: > /SAP/SQL/funcs/spi/cascade.o: ELF file's phentsize not the > expected size > > What can I do ??? > > _______________________________________ > David Martinez Cuevas > Direccion General de Estadistica, UNAM - Mexico > Tel. 622-60-80 > E-mail david@estadistica.unam.mx > ---------------------------------------- > > > > > > >