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
. 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
match, 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
8.3/interactive/plpgsql-structure.html
--
Sincerely,
Shawn Tayler
Radio Network Administrator
Washoe County Regional Communications System
Telecommunications Division
Technology Services Department
County of Washoe
State of Nevada
Ofc (775)858-5952
Cell (775)771-4241
FAX (775)858-5960
--
Sen
le functions as this are better written in the SQL language.
> I
> can't speak for the validity of the code itself, but you can rewrite
> it
> as
>
> create function f_csd_interval(integer) returns interval as $$
> SELECT $1 * interval '1 msec'
> $$ LA
#
The error at or near END is curious. There must be something wrong 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:1
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 Administrat
