Re: [GENERAL] Statistical aggregates with intervals

2012-08-23 Thread Christopher Swingley
functions work: CREATE OR REPLACE FUNCTION interval_to_seconds(interval) RETURNS double precision AS $$ SELECT (extract(days from $1) * 86400) + (extract(hours from $1) * 3600) + (extract(minutes from $1) * 60) + extract(seconds from $1); $$ LANGUAGE SQL; Cheers, Chris --

Re: [GENERAL] to_tsquery, plainto_... avoiding bad input, injections. Is there a builtin function for this ? Escaping?

2009-01-08 Thread Christopher Swingley
Greetings! > Wed, Jan 7, 2009 at 8:07 PM, Mohamed > > Hi, I am wondering whether or not there exists any built in > > function for making sure a query/textinput is not harmful or one > > that escapes them. If not, what kind of things should I watch out > > for ? > > * Reg Me Please [2009-Jan-08