Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id D1D402E0092
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 26 Mar 2008 20:41:43 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 57273-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 26 Mar 2008 20:41:41 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.xmtservices.net (unknown [66.224.65.210])
	by postgresql.org (Postfix) with SMTP id 2ED052E008E
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2008 20:41:41 -0300 (ADT)
Received: (qmail 12019 invoked from network); 26 Mar 2008 23:41:39 -0000
Received: from unknown (HELO vaio.xmtservices.net) (192.168.0.101)
	by errol.xmtservices.net with SMTP; 26 Mar 2008 23:41:39 -0000
From: Shawn <postgres@xmtservices.net>
To: pgsql-sql@postgresql.org
Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Date: Wed, 26 Mar 2008 23:41:38 +0000
User-Agent: KMail/1.9.9
References: 
 <032620081632.25756.47EA7AA200070FAB0000649C22007374789D0A900E04050E@comcast.net>
	<200803262245.53968.postgres@xmtservices.net>
	<a55915760803261612n16a87064y6abca46a0cdc42f8@mail.gmail.com>
In-Reply-To: <a55915760803261612n16a87064y6abca46a0cdc42f8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200803262341.38648.postgres@xmtservices.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/189
X-Sequence-Number: 30517

On Wednesday 26 March 2008 23:12:07 Rodrigo E. De Le=C3=B3n Plicet wrote:
> Use dollar quoting, e.g.:
>
> create or replace function dur_interval_msec(int) returns interval
> as
> $$
> select ($1 * interval '1 msec');
> $$
> language sql
> immutable
> returns null on null input;

Perfect! Great!  Thank you!

There are so many things about SQL I don't know....

Shawn