Re: [SQL] Cumulative result with increment

2011-02-08 Thread Shawn Tayler
Thanks Steve, That did the trick! I appreciate the help Shawn On Mon, 2011-02-07 at 14:13 -0800, Steve Crawford wrote: On 02/07/2011 01:11 PM, Shawn Tayler wrote: Hello, I am struggling with what is probably a simple problem but I am coming up blank. In the interest of full

[SQL] Cumulative result with increment

2011-02-07 Thread Shawn Tayler
. Its the rest that has me stumped. Any suggestions or direction? As always, your help is greatly appreciated. -- Sincerely, Shawn Tayler -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] varchar value comparisons not working?

2009-04-24 Thread Shawn Tayler
, at least 2 (there are more than shown). But instead I get this: count --- 0 (1 row) What am I doing wrong? -- Sincerely, Shawn Tayler Radio Network Administrator Washoe County Regional Communications System Telecommunications Division Technology Services Department County

Re: [SQL] Creating a function with single quotes

2009-02-20 Thread Shawn Tayler
in the line before it but I can't see it. Suggestions? In case it matters, the server is v8.2.11 compiled from source on Slackware 11.0 and the terminal is v8.3.6 running on Ubuntu v8.10. On Fri, 2009-02-20 at 08:11 +, Jasen Betts wrote: On 2009-02-19, Shawn Tayler stay...@washoecounty.us

[SQL] Creating a function with single quotes

2009-02-19 Thread Shawn Tayler
representation of an interval. create function csd_interval(integer) returns interval as 'BEGIN RETURN $1 * interval '1 msec' END;' LANGUAGE 'plpgsql'; it always fails at the '1 msec' point. Suggestions? -- Sincerely, Shawn Tayler Radio Network Administrator Washoe County Regional Communications