[GENERAL] Re: anti Christian bias?

2001-04-14 Thread Stefan Waidele jun.
I might not be able to change the standard but: How specific is BCE? 1973 Before the Current Era my birth year, but _only_ under that very pro-christian assumption that BC = BCE ! the last item in the Example column is January 8, 99 BC. The corresponding Description item reads "Year 99 before t

[GENERAL] Re: interval output format ?

2001-03-19 Thread Stefan Waidele jun.
Hi David, I had the same problem, and here is my solution (I posted it on Pg-Novice quite a while back): Q: How do I have an interval displayed only in 'hours:minutes' instead of the default 'days hours:minutes' A: My solution is a function like this: CREATE FUNCTION "to_hours" (interval )

[GENERAL] Re: Paradox, dbf and PostgreSQL ?

2001-03-07 Thread Stefan Waidele jun.
At 02:17 08.03.2001 +0100, Thomas Nagy wrote: >Hi, > >I'm from Nantes, France and I've started learning PostgreSQL a few weeks >ago. I've read the manual, but I'm still new, so just tell me if I write >nonsense. > >My Brother is still on winchose, and he has sent to me some *.dbf and >paradox d

[GENERAL] Re: interval question

2001-03-06 Thread Stefan Waidele jun.
At 21:59 05.03.2001 -0300, Fernando P. Schapachnik wrote: >[...] > I want to know which ids are current, ie, which satisfy >start<=now<=start+duration. > > The problem is that start+duration is an interval, and I >can't find the way to cast now to interval or interval to time or >t

[GENERAL] Re: numeric type and odbc from access 2000

2001-02-08 Thread Stefan Waidele jun.
At 15:47 07.02.2001 +, Richard Huxton wrote: >[...] It is treating "100.200" as float and can't find an '=' operator that >matches numeric with float. You can handle it with > >where col3=100.200::numeric Yes, we can, but Access cannot, I have not found out how Delphi can, either. If You Quot

[GENERAL] Re: clean rebuild process?

2001-02-06 Thread Stefan Waidele jun.
At 15:02 06.02.2001 -0500, chris markiewicz wrote: >the limit of my imaginatin is this - some sort of command/utility that >queries a table and generates the insert statements from the results. then >i wouldn't have to worry about updating my default data scripts everytime >data changes. pg_dump