comp.databases.filemaker - Technical discussions about FileMaker.
I have the need to output intervals (ages in this case). PostgreSQL takes great care to handle months correctly (eg take into account varying months lengths). This is only possible if either end point or start point of an interval are known. For post processing some of the ambiguity of what "2 mons" means would be removed if "61 days" was returned. Is there a way to tell PostgreSQL to return that type of interval (eg use weeks, days, hours, minutes, seconds, ... but not months and perhaps not even years [leap years, etc]) ? to_char(interval, text) doesn't work as it is applied after the fact. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
3. Remove text
FM8.5 I have made a mistake in my set up. When I created my Invoice # (kp_InvoiceID) I include the text 'Inv' as in Inv 10-00010, an on creation serial number. I would like to remove the Inv from all the Invoice serials without loosing the serial number. This would allow me to search a kp_InvoiceID based value list without having to write Inv each time. Can you help me? Thanks Matthew
I have a stanard database with Name, Address, Phone etc etc and I'm having the following problem: People cut and paste text in from their email and the internet, and that formatted text goes into the fields of the database and doesn't match the settings for the field. I tried to insist on specific formatting using the calucated result field, but then it's permanently formatted that way in every instance of the text in question. Is there some calculated result that REMOVES FORMATTING--kind of like paste unformatted text so that the formatting will merely be the formatting of the field they are pasting into? Thanks. David Averbach