On Monday 10 August 2009, Richard Neill wrote:
> * So, for example, to check whether two timestamps (ts1 and ts2) are less
> than 2.5 seconds apart, (returning boolean), I'd like to be able to do at
> least one of:
>
> abs(time(ts1 - ts2)) < 2.5
> #A "time" function converts timestamp to
> #s
On Friday 15 May 2009 09:16:33 Peter Eisentraut wrote:
> On Friday 15 May 2009 01:07:11 Hershel Fisch wrote:
> > Hi, I realized that sorting date is done like text and not numeric
> > (dates) e.g. SELELCT * FROM database_name ORDER BY date ASC
> This report would make a lot more sense if you p
On Thursday 30 October 2008, Tomáš Szépe wrote:
> > A pg_dump run is comparatively short-lived, so if Zdenek is right then
> > there's no important leak here -- we're counting on program exit to
> > release the memory. There's probably little point in releasing things
> > earlier than that.
>
> W
On Wednesday 20 February 2008, Gregory Stark wrote:
> Unless you need cryptographic security I would not suggest using MD5. MD5
> is intentionally designed to take a substantial amount of CPU resources to
> calculate.
I thought it was the exact opposite, quoting from RFC1321:
The MD5 algorithm i
Hi:
> Having two timestamps it is common need to know how many
> seconds/minutes/hours/days/etc. passed from one to the other. However there
> is no easy way to do this task.
> The basic idea is subtracting the two timestamps. However it gives a data
> type called "interval". The thing I woul
On Thursday 30 October 2003 19:18, Bas Scheffers wrote:
> > This is not a bug. If there is not file named ~ then it can't be
> > opened.
> I am not trying to open a file named ~, I am using it as part of a file
> name, ie: ~/ewap/sql/ewap.sql. (where ~=/home/bas) This is perfectly valid
> on any
